In your workbook shown running sum of overall sales total only. it will not sum with last value.
Good morning Sankar,
Unfortunately, I am aware of that . My question is how to do I obtain an accurate Total as well as display the most recent data for the days. Posb using a calculating field, as the grand total function usually doesn't work well with the Last() command - which is why I am seeking a calculating field to calculate the most recent days. I believe this would solve the Grand Total issue.
1 of 1 people found this helpful
Hi Bill W
We can do it by windows Calculations.............
1) create a calculated field withe the following logic,
2) Drag the above calculated field into Work Area, Then right click on
that, Then click on "Edit Table Calculations".
3) Then Define that Addressing , Partitions accordingly.
Anyone else have any ideas?