Let me know how to calculate this?
I have an cross table like the attached. I would like to calculate the change column dynamically, ie., 03/31/15 - 02/27/15.
When the date changes the change column should be calculated automatically.
Here is the axes Properties. Horizontal : Date. Vertical - Sect Name . Cell Values - Amount
Please let me know. Thanks