chart

[#1]

Hi All,

I want to create a chart with product and year  as dimensions and sum(sales).

What I want to do is: for all the year up to 2012 I want sum(sales) but for 2013 I want to have 12 rolling month (sales) ,lets say from july 2012 until now.

Anybody has any idea, I appreciate!

Thanks

[Gysbert_Wassenaar]

I think you'll need an AsOf table for this. See this document for an explanation. Your expression will then have to check if the year is 2013:

If(Year=2013,

    sum({<Type={'Rolling 12'}>}Amount),

   sum({<Type={'Current'}>}Amount)

)

[#3]

Hi,

Thanks for the reply but I think something is missing !

As I see for 12 month as we have month from last year which is not corresponding the current year (2013), it does not show the 12 months correctly and it only shows the 2013 data.

I also added year in the asOfTable and it didn't help.

Any idea?

Thanks