This is because you can calculate index only on dimension and not on measure.
Is there a work around to it?
Please mention clear requirement here. If you create index() then you can drag to row or coloumn or marks card and also try to add any dimension in worksheet.
When you select index calculated field then you can see compute based on dim.
BI, Aspire Systems (India) Pvt Ltd
I have created a calculated measure ‘Alert Type’ which flags my customer as ‘Upward’ or ‘Downward’ based on the average of last 3 months. The Alert Type measure is based on a table calculation (windows_avg). What I am trying to achieve is to find Top N customers within each one of the Alert Types (Upward or Downward). For which, I need to index my customers based on Alert Type measure.
Hope this helps.
Please mention what's your requirement along with data.