I'm trying to create a table in Apptio BI that displays Amortized Cost by Month, using 'Product' as the dimension and 'Amortized Cost' as the metric. I want the table to show products with the highest cost first, so I select 'Amortized Cost' as the sort measure. However, when I enable the 'View By' option in the Date Range settings to show monthly data, the option to sort by 'Amortized Cost' disappears-only 'Product' remains available for sorting. Is there a way to keep the monthly view enabled and still sort the table by the metric instead of the dimension?
------------------------------
Sreelakshmi Gopalakrishnan
------------------------------