Cumulative Total by User, Stacked Bar Chart

[fosterma]

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,

[ariel_klien]

Hi,

please see the attachment.

is that what you are looking for?

Ariel

[sunny_talwar · Accepted solution]

Like this?

[fosterma]

Yes, I think so Sunny

So the end result would look like as below but split by user for each month as you have above

[sunny_talwar]

Right now we only have one month of data that you have provided. I guess can you try the above example on your end and see if this is working for you or not?

[fosterma]

Thanks Sunny