Help wirh getting previous month

[#1]

I have a pivot table where I am showing the last 4 months of data. Like this:

Month                Count                Previous            Change

Jun-2014            42,115              63,227               -21,112

May-2014           63,227              59,126                4,101
April-2014          59,126              58,595                 531

Mar-2014           58,595               -                          -

I am currently using  Below(column(1)) to determine the amount in the 'Previous' column.  

However, using this method presents an issue on determining the 'Previous' for 'Mar-2014' since the previous month 'Feb=2014' is not being displayed in the chart.

Is there a way to use set analysis and change the way 'Previous' is calculated so that I can get that earliest month in the chart?

[Anonymous]

why not use the same expression that you use for "Count" with set analysis to find the previous month? something like below:

insert correct field names and modify expression for your requirement.

count ({<Month={"=addmonths(/*Date*/,-1)"}>} /*ID*/)

[#3]

Thanks jsaradhi. I think this might work, but what would the date field look like in  (/*Date*/  date field you have listed. Can you walk me through what I would change it to?

[#4]

Tried this

(DISTINCT{<Month={"=addmonths(Max([Event Date]),-1)"}>}Event.User)

but gave me the current count and not the previous. What am I doing wrong?

[#5]

I saw you replied but it did not come through