This content has been marked as final. Show 2 replies
To extend the row banding formatting to Market and Product you can use INDEX() in a calculated field to ungroup those fields. See the steps below. Let me know if this is what you were looking for!
- Create a new calculated field with the formula: INDEX()
- Right-click the new calculated field, named Index in the attached workbook, and select Convert to Discrete
- Drag Index from Measures to Rows left of Market
- Go to Format > Shading and drag the Level slider all the way to the left
- Right-click on Index on the Rows shelf and click Show Header
Thank you very much for the help sarah.