4 Replies Latest reply: Feb 14, 2012 2:17 PM by ludovic cousin RSS

    How to build a waterfall that bridge Budget to Actual for a single dimension (account)?

      Hi all,

       

      We need to build a waterfall chart that bridge the Actual Amount and Budget Amount for an year with Account as the only one dimension.

      The start bar should have the Total of Acutal amount for all the account and the end bar to have total of Budget Amount for all the account.

      The bars in between to have the account level variance (Actual - Budget). The number of account (dimension) appearing in the chart is

      dynamic based on the user selection.

       

      Can anyone suggest how to build the solution?

       

      Regards,

      Rajesh