I am trying to calculate running total of a measure that I have created, I can get the pivot table to show it using "show Value As" however I cannot achieve the same using a new Measure and I need a new measure so I can then calculate year to date average

using the following formula I get sum of individual rows rather sum of aggregated rows per month

Any Assistance, would be appreciated,

Thanks


Please Login or Register  to view this content.
screenshot runing total prob.PNG