Forum Discussion

admin_xlsior's avatar
admin_xlsior
Post Prodigy
7 years ago
Solved

Show Item in Tabular column for Matrix Visualization

Hi guys,   I created a report using Matrix visualization, something like this :   Question is how to make it all under 1 row ? In Excel Pivot table, we usually have an options called "View ...
Need Help
  • MFelix's avatar
    MFelix
    7 years ago

    HI admin_xlsior ,

     

    Go to the options of the matrix table and look for the stepped layout option and turn it of.

     

     

    Regards,

    MFelix

admin_xlsior's avatar
admin_xlsior
Post Prodigy
7 years ago

Hi,

 

Many thanks. it's just what I'm looking for.

 

Now I wonder if it is can be  done for the Column as well.

So I have Quarter in my columns, and 2 Values :

- Actual 

- Standard

like below :

 

 

Currently it show Quarter at the top with each Quarter divided by the 2 Values :

 

I'm thinking I want the other way around, so Actual and Standard at  the top, then divided by Quarters, like below:

 

If I look at the Format setup for Column Header, it's doesnn't have the Stepped layout.

 

Is it possbile to turn that around ?

 

Thanks in advance,

 

 

 

 

 

VeronikaB's avatar
VeronikaB
Frequent Visitor
6 years ago

Hi, 

I am currently facing the same issue/question. If you or anybody came up with any idea in the meantime how to do that it would be very helpful for me because I have not found the exact solution so far to have this kind of view (sorted time quarters under the name of actuals, revenues measure).

I only have live cube connection what causes limited option in modeling tab section.

Thank you.