Table Format and Analysis

[#1]

Hello to all,

I'm having some issues to make a table in the format of the one in the spreadsheet attach.

Using the pivot table, I can't get the information in this format.

Please note that I have those two fields (Expenses and Budget).

Thanks for your support.

Let me know if you need more information.

[awhitfield]

Hi Marco,

can you upload an example QVW?

Andy

[sunny_talwar]

What is the issue when you try to create the table in a certain way?

[marcus_sommer · Accepted solution]

If you want to combine the columns like in the excel then you would need either to use for each an own expression (15) or you need to create Budget - Expenses and Budget as calculated dimensions and could then use month as horizontally dimension.

- Marcus

[#5]

Marcus,

Thanks for the solutions proposed. I created one column for each expression and it worked perfectly. If my performance gets affected I'll evaluate if it would be better to use the second solution proposed.

Thanks a lot to all for the answers.