0 Replies Latest reply: Mar 7, 2013 5:37 PM by Anthony Wood RSS

    Block Chart Show breakdown of sum of two columns

      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 NameBusiness UnitMaintenance SpendLicense Spend

      ABC

      Finance10,0005,000
      DEFOperations20,0002,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.