Limit number of columns

[#1]

Hi,

I have a variable MonthYear, structured like this: oct-2011, in a dimension, showing the number of sales per month. In a sales table (either straight or pivot) I want to show the sales for the previous 13 months.

How can I limit the number of columns shown in this table?

Thanks!

[#2]

Hi,

In the back end script create a flag if the date falls within 13 months period, then in the table (pivot or straight) you can write the expression like this:

sum(if(Flag=1,Amount))

Hope this helps you.

Cheers.

[#3]

Hi,

How do I write that script for the flag?

thanks!

[#4]

Hi,

Please find the attached sample may help you.

Cheers.