5 Replies Latest reply: Apr 13, 2016 3:45 AM by Mark Foster RSS

    Cumulative Total by User, Stacked Bar Chart

    Mark Foster

      Hi All,

       

      I'm attempting to create a stacked bar chart as attached drawing.

       

      I have 'Invoice Date' as a dimension displayed as Month Year and I'm trying to show Total Amount accumulated by user per month as an expression.

      I've defined it as follows, but I'm not getting the desired results. I'm Probably going about it the wrong way.

      =aggr(Sum({$<[Invoice Year]={"$(=Max([Invoice Year]))"}>}[Total Amt.]), [User Name]))

       

      Example Data:

      Invoice Date | Department | User | Total Amt. |

      01/01/2016 | Operations | User A | £10

       

      01/01/2016 | Operations | User B | £15

      01/01/2016 | IT | User C | £30

       

       

      01/02/2016 | Operations | User A | £20

       

      01/02/2016 | Operations | User B | £10

      01/02/2016 | IT | User C | £10

       

       

       

       

       

       

       

       

      Can anyone help point me on the right path?

       

      Thanks,