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

     

     

     

prihana's avatar
prihana
Helper V
8 years ago

Add both Type and description under Rows. Click on at the lowest level of data to expand it (grouping by Type)

  • venug20's avatar
    venug20
    Resolver I
    8 years ago

    Hi Prihana,

     

    thanks for respond my post,

     

    I have already tried, which has provided solution like below... this is known format.... i am asking like above format....

     

     

    Pls help any one on my issue....

     

    thanks in advance....