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.