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
screenshot runing total prob.PNGPlease Login or Register to view this content.
Bookmarks