Hello
I can't get Excel and the Pivot I have made, to use the running total (the accumulated sum) when I am trying to use it in a calculated field. Does anyone know a way to make a calculated field, that uses the running total in calculating something else in a pivot? Or is there another way to calculate with the running total? It has to be done in the Pivot itself, since the data that I'm using shouldn't be touched.
Best regards
I can't get Excel and the Pivot I have made, to use the running total (the accumulated sum) when I am trying to use it in a calculated field. Does anyone know a way to make a calculated field, that uses the running total in calculating something else in a pivot? Or is there another way to calculate with the running total? It has to be done in the Pivot itself, since the data that I'm using shouldn't be touched.
Best regards
