Pivot Table Last month Sales

[#1]

Hi all,

I have a pivot table with Month (field MONTH-Yr) as Dimension, and Sales as Expression.

I want to show the previous month sales as a new Expression. Also the month for January should be populated.

Note: I have YYYYMMID filed which is an integer autonumber based on field YYYYMM which I think could facilitate the problem..

Sample app is attached.

I appreciate all the help!

Thanks,

Jon

[sunny_talwar]

I suggest looking into The As-Of Table for the best solution for your scenario