Year and Month value Calculation

[#1]

Hi,

I am trying to compare values from this year this month and last year this month in pivot table.

For this year column I am using:

sum({<Invoice_Date.Year = {$(=GetFieldSelections(Invoice_Date.Year))}, Invoice_Date.Month = {$(=GetFieldSelections(Invoice_Date.Month))}>} [sop.val])

and for last year this month column i am using

sum({<Invoice_Date.Year = {$(=GetFieldSelections(Invoice_Date.Year)-1)}, Invoice_Date.Month = {$(=GetFieldSelections(Invoice_Date.Month))}>} [sop.val])

however the values showing are all zeros.

Any help will be greatly appreciated

[#2]

Hi,

try to evaluate the example.

Good luck!

Rainer

[#3]

Thanks Rainer,

It shows the aggregate for last three month. Is there any way to identify figures for last year this month.

[#4 · Accepted solution]

Hello again,

I have modified the application in the way you asked.

Hope it helps a lot!

Rainer

[#5]

Here are the attachment.

[#6]

Many Thanks. It worked.