Forum Discussion
running total in pivot table when grouping dates
in my file there are sums in the context of dates. I formed a pivot table where in the rows of the date, in the columns of the sum. I need to output the running total. for this, the field was re-displ...
In general yes, but first please try on copy of your file if you are ready to add data to data model. On any PivotTable click on More fields
Excel asks to create new PivotTable
Click Yes, new PivotTable will be created and data added to data model. But you will lost all PivotTable formatting and shall format/group/filter/add slicers from scratch. That's time consuming operation, but better than create new PivotTable from scratch.
Thus I'd suggest you to try on one PivotTable, if it's worth to do such way I'll help to create the measure.
I will be very grateful to you. never faced pivot. tomorrow I will definitely try to figure it out. if it doesn't work, with your permission, I'll show you the file. it is very important to get the result