Cumulative total by org and billing period

[Kelsey024]

Hello,

I am trying to create a table that shows the cumulative/running total by each fund/org and billing period, similiar to this:

How do I do that? I tried using this calculated column:

Running Total = CALCULATE(SUM('DETAIL WATER'[Consumption]),FILTER(ALLSELECTED('DETAIL WATER'),'DETAIL WATER'[Billing Period]<=max('DETAIL WATER'[Billing Period])))

But this is what I got (which is obviously not correct!):

 I appreciate any help!

Thank you!

Kelsey

[v-chuncz-msft · Accepted solution]

@Kelsey024,

Just use ALLSELECTED ( 'DETAIL WATER'[Billing Period] ) instead.

[Kelsey024]

Raw data looks liks this: