Filter in Last 12 Month formula

[#1]

Hi,

I have a formula in Pivotable :

Sum({1<[Kalender.Kalender.Eindeutiger Monat]= {"$(='<='&Only([Kalender.Kalender.Eindeutiger Monat])&'>'&Only(date(addmonths([Kalender.Kalender.Eindeutiger Monat],-12),'MMM-YYYY')))"} >} Billing_Header.Billing_Header.Net_Value_Inv)

It works Ok, but when i filter for just one Customer, it show the same value as for all Customer.

Can anybody Help .

Thanks

Regards

[#2]

Hi,

Please, remove the "1" symbol on the begining of the set analysis formula.

"1" - means "do not care about the current selection" 🙂

Instead, put the "$" sign.

Best regards,

JTPro

[#3]

Hi,

Thanks, i remove 1 and replace with $. it show just one Month not L12 Month. the value is just for one Month

i select in Calender 2009 March for the Sales of Last 12 Month (March-2009). i will see the April-2008 to March 2009

see blow

Sum({$<[Kalender.Kalender.Eindeutiger Monat]= {"$(='<='&Only([Kalender.Kalender.Eindeutiger Monat])&'>'&Only(date(addmonths([Kalender.Kalender.Eindeutiger Monat],-12),'MMM-YYYY')))"} >} Billing_Header.Billing_Header.Delivery_Charges)

March-2009 180

Best regards,

Shideh