yearly sales

[Anonymous]

hello everyone,

i come to know ,when i select on 2017 years it will shows last three years of data in three different pie chart like below.

How it will be possible?

for eg.

[tresB · Accepted solution]

Try like:

Chart1 Exp: = Sum({<year={'$(=Max(year))'}>}Sales)

Chart2 Exp: = Sum({<year={'$(=Max(year)-1)'}>}Sales)

Chart3 Exp: = Sum({<year={'$(=Max(year)-2)'}>}Sales)

[Anonymous]

Thanks, It works perfectly.