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. My goal is to sort the table so that products with the highest cost appear first.
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. The only available sort option becomes Product, which doesn't meet my reporting needs.
Expected Behavior: I would like to enable a monthly view and still be able to sort the table by Amortized Cost (descending).
Actual Behavior: Enabling "View By" restricts sorting to dimensions only, and the metric is no longer available in the sort options.
Request: Is there a way to maintain the monthly breakdown while still sorting by a metric like Amortized Cost? If not, could you suggest a workaround or confirm if this is a known limitation?
Thank you!
Sree
Hello @Sreelakshmi Gopalakrishnan, I would like to request you about connecting with your Customer Success Manager (CSM) as this question is related configuring the views in Apptio BI.Hope this helps.