6 Replies Latest reply: Sep 4, 2016 8:10 PM by Light Section RSS

    Budget vs Actuals - How to show budget values over Revenue for each Business Hierarchy

    Light Section

      Data.png

       

      Above is an example of how Budget Table and Sales Fact table look like. I have joined both tables using a composite key that is based on the common fields in both tables.

       

      What I would like to do is:

      Display the Total budgets for each industry in a graph (for eg. the below graph should show the total budget amounts for all the 4 respective industries). Currently it is only showing bar values for revenue, i would like to add a marker at the top showing budget amounts, which are basically targets.

       

      Challenge: How to keep the expression dynamic based on what selection user makes. As you can see above, the totals and individual values are all displayed as separate rows in the budget excel sheet.

       

       

      Bar Chart.png