Forum Discussion
Dimani
Helper II
Helper IIMonthly cumulative values for pivoted data?
Hi A colleague is working on some monthly numbers, for different categories, and she wants to calculate and graph the running sum by month too. Her data are already pivoted in Excel, and she...
Hi Dimani ,,
The approach
"
Also, in terms of calculating the running sum, I saw some examples that other users use the unpivoted data and a measure to calculate the running sum. Is that a better approach than using the pivot monthly data to calculate the running sum?"
is the best.
Cheers
CheenuSing
DimaniHelper II
Helper IIThanks for your information, CheenuSing.