Is there a way i can show the latest 3 months in the chart properties?

[aaronnayan]

Is there a way i can show the latest 3 months in the chart properties?

(Most Recent)

There are options for the first, largest and smallest

The month field is DEC_Month

[tresesco]

In the dimension limit tab - Restrict..Show Only->Largest/Smallest -> define your number (3 here)

[aaronnayan]

To show the latest months

Only the newest months, (most recent)

[Anil_Babu_Samineni]

May be use expression, Something like below to show only 3 months which is latest one

Sum({<DEC_Month = {">=$(=AddMonths(Max(DEC_Month), -3)) <$(=Max(DEC_Month))"}>} Sales)

[aaronnayan]

Does not work, Not as a variable

[Anil_Babu_Samineni]

Are you replying to me? Or for Tresesco. Any way, If your question is relevant to expectation then my expression should work in front end. If question was different then i apologies for that

[aaronnayan]

HI Anil

Very sorry but that does not work

It shows 4 months

Is there anyway i can get the top 3 selling months for the "sales assistant"_ "BOB"

[Anil_Babu_Samineni]

May be look FirstSortedValue()