Forum Discussion
Solved
Display data in matrix Visual like tabular format
Hi Every one, I have raw data like below Row Labels Sub-Category Sum of Sales Furniture Bookcases 1522871.988 Furniture Chairs 1681154.762 Furniture Furnishings 442367.473...
Hi venug20,
Do the following to achieve what you want
1. Add both Row Labels and Sub-Category to Rows and Expand
Matrix with Rows Expanded
2. Switch off the Stepped Layout option as shown in the pic below
Switch off stepped layout
3. Modify the Row Subtotals as shown below
Modify the Row SubtotalsYour Output will look like the one below
Hi venug20,
Do the following to achieve what you want
1. Add both Row Labels and Sub-Category to Rows and Expand
Matrix with Rows Expanded
2. Switch off the Stepped Layout option as shown in the pic below
Switch off stepped layout
3. Modify the Row Subtotals as shown below
Modify the Row SubtotalsYour Output will look like the one below