Create a calculated field called RowIndex with the formula: INDEX()
Drag this to the rows shelf, right click and select Discrete, then move to the very left of the table. You can then right click it and select 'Show Header' to remove it from the view.
To show Region and Port_Speed on every row you can use INDEX() in a calculated field to ungroup those fields. See the steps below.
- Create a new calculated field with the formula: INDEX()
- Right-click the new calculated field, and select Convert to Discrete
- Drag Index from Measures to Rows left of Region
- Right-click on Index on the Rows shelf and click Show Header
I've also attached a workbook as an example. Let me know if this is what you were looking for!
Thank you. Worked like a charm!