Forum Discussion

admin_xlsior's avatar
admin_xlsior
Post Prodigy
7 years ago

Leveling in column

Hi guys,

 

I have this situation whereby I need to switch the levelling of my report. It's like below.

 

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

- Actual 

- Standard

like below :

image.png

 

 

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

image.png

 

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

image.png

 

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.

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi admin_xlsior ,

     

    Can you try this with Matrix visual, hope you will get data as you want.

    Thanks,
    Amit

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support
    7 years ago

    Hi admin_xlsior ,

     

    Could you please share your sample data to me if you don't have any Confidential Information.Please upload your files to One Drive and share the link here.

     

    Regards,

    Frank