I was wondering if it is possible to show the total of two columns in a table and break it down into two components.
My data is like this:
Application Name
Business Unit
Maintenance Spend
License Spend
ABC
Finance
10,000
5,000
DEF
Operations
20,000
2,000
And i have a block chart that I want to show the sum of the Maintenance spend and licence spend per Business Unit. And then I would like to further break that sum down into the proportion spent on maintenance and Licence.
I have Business unit as my first dimension, but am unsure of what to use as my second dimension.
