Forum Discussion

venug20's avatar
venug20
Resolver I
8 years ago
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...
Need Help
  • Thejeswar's avatar
    Thejeswar
    8 years ago

    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

     

     

     

Thejeswar's avatar
Thejeswar
Super User
8 years ago

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

 

 

 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Additonal Solution: If you want to repeat column 1 values then just create the table in matrix, turn off stepped layout,  THEN --> select the matrix and change the visualization type to "Table".