Above/Previous? Issues with current month data

[#1]

Hi all,

I have a requirement which is as follows: 

- A bar chart with 2 dimensions , Date and type

- Each month shows the previous months' data

I have used the above function for this and it works for everything apart f4rom the current month (for which there is no data).  e.g. The chart presents correct data until August but September does not get populated so the above function only qworks up until a point.

I also tried the previous function in my script but was unable to get it to work as i was unsure how to order it as there a number of keys in the fact table.

Has anyone any other ideas/examples?

Would be much appreciated.

Thanks

[whiteline]

You can use an if(rowno()=1) statment as a workaround.

But maybe, it's beeter to change the months labels.