prior period comparison

[omyahamburg]

Hello all

Can someone help ? My head is blocked by end of this week.

I have a table where I show a sum for a dimension Periode:

Periode	Sum (Restmenge)
2013-Jan	6.125.024,43
2013-Feb	5.932.647,27
2013-Mrz	5.716.283,74

Periode is coming out of my script:

year (Date)&'-'&month(Date) as  Periode

How to I write the expression to sum Restmenge for 2012-Jan and so on ?

Thanks for your help.

Joerg

[kaushiknsolanki]

Hi,

     Instead of

     year (Date)&'-'&month(Date) as  Periode

     Create a filed Periode as Monthname(Date) as Periode.

     This will result into Mar 2013 and so on.

     Now You can use below expression to get the last month data.

     =sum({<Periode= {"$(=Monthname(addmonths(max(Date),-1)))"},Year=>}Sales)

Regards,

Kaushik Solanki    

[omyahamburg]

Dear Kaushik

Thank you, I'll try latest on Monday and will let you know.

best regards

Joerg