This content has been marked as final. Show 3 replies
I have a table like this:
When I select Apr, the Pivot Table only shows:
|Total = Sum(Amount)||322|
How could I make Total to be sum of Feb's, Mar's and Apr's amount, i.e. rolling 3 months, and giving out 856, i.e. 232 + 302 + 322?
Please help and advise. Thank you.