Rolling 12 Month: a problem....

[#1]

  Hi all,

I found the attached file in the community.

It is an example well done and very useful

In the sheet "Sheet2" if I select a value from Region do not change the values in the table.

How can I do for the selection also to the Region dimension?

Thank

[Gysbert_Wassenaar]

The expressions start with sum({1<OrderDate={. The 1 means ignore all selections. Remove the 1 and the selection of a Region will be reflected in the calculation.

[#3]

OK Gysbert,

you're right.

But I would like to be able to keep the 12 months in the dimensions and also the ability to select a value for the Region

Thank

Sbuzi

[Gysbert_Wassenaar · Accepted solution]

Try sum({<Month=, MonthYear=, OrderDate={">=$(=addmonths(monthend(max(OrderDate))+1,-12)) <=$(=max(OrderDate))"}>}Sales)

[#5]

Why do you enclose two '' - is that nessecary?

[#6]

Thank you VERY MUCH