I want to present only the last 3 months (dimension) in a line diagram

[Anonymous]

I presented the months in de x-axis en the results of the months (number of prints) in de Y-axis.

I want to limit the x-axis to last tree months. How do I do that?

[giovanneb · Accepted solution]

Hi try this, use set analysis

sum({1<OrderDate={">=$(=addmonths(monthend(max(OrderDate))+1,-3)) <=$(=max(OrderDate))"}>}Sales)

[Anonymous]

hy Giovanne, thanks for your reply. I had a lot of struggle with the notation. For now, it seems to works. Thanks

[giovanneb]

Please if suggestion answered wax the topic marked the correct answer.

Regards