1 of 1 people found this helpful
Please follow below steps:
1. Index = INDEX()
Drag this column before "Measure Name". Right click on "Index" and uncheck "Show Header" option.
2 of 2 people found this helpful
I don't think you can achieve this using tableau generated Measures Name which is not a real dimension, in that case INDEX() will not recognize the Measures Name as partition. To achieve that you need to work on your data source. You've to transpose the measures from columns to rows. Then you can use as dimension. Once done then you can create a calculated field to concatenate with Zone to make it unique ID and place it at first in rows shelf and hide the header.
Got it. Thanks for the clarification.
What I originally want to do is to export this table to Excel which contains three columns: "measured names", "new zone name", and "value".
I found that Mahfooj's approach is the most efficient one if the data is tidied up as advised.
Yet, Meenu's approach works, too, in this case because I can export this four-column table to Excel, delete the first column "index", and sort the remaining columns:
A "cheating" approach I found is to drag and drop the "measured names" into Rows again. Similarly, I can delete the first column once the table is exported to Excel.
Thanks a lot, again, and I learned a lot from both of your suggestions.