Calculation sum of an amount in currentMonth date and in PreviousMonthDate

[mario-sarkis]

ID    PeriodDate      Amount

x      Jun-2014      1000

x      Jun-2014      500

x      July-2014      1000

x      aug-2014      500

My requirment is i need to show an Pivot table that contain  (sum of amount of the current and previous month in orger to find the lost amount) Lets suppose my current month is July  and my previous is jun

ID            CurrentMonth          PreviousMonth

X              1000                        1500

and once i select to August my current month will be August and previous month will be july                  

    ID        CurrentMonth        PreviousMonth

X        500                          1000

of caurse in my date have many ID Please note that my periodDate has a num form and i created the monthName field since i have date in a month don't have it in the other  so my calculation sum(max(currentmonth))-sum(max(PreviousMonth)

Thank you hope you can help.

[sunny_talwar]

This?

Dimension: ID

Expressions:

=Sum({<PeriodDate = {"$(=Date(Max(PeriodDate), 'MMM-YYYY'))"}>}Amount)

=Sum({<PeriodDate = {"$(=Date(AddMonths(Max(PeriodDate), -1), 'MMM-YYYY'))"}>}Amount)