Lock filter

[#1]

Hello

I want to know how to block a single filter for a specific graphic (because there are several graphics).

In my case, I have "year" filter, my formula detects the most recent two years with the month in common to compare the turnover etc! until then it's perfect except that I would block the selection of the "year" filter to not select another year and to only use the other filters as country etc...!

thank you in advance

Stephane

[#2]

for information:

My request for help:

for example:

-"Year" filter :2009/2010/2011

-"Country" filter: France/German/USA/INDIA...

- Quantity

- Price

=sum({$<Years ={$(=Max(Years))}>} Quantity*Price) = 10000€ (turn over for all country) represente 2011

=sum({$<Years ={$(=Min(Years))}>} Quantity*Price)= 9000€ (turn over for all country) represente 2009

After that if i choose other year my result change but i don't want that, i want my result change only if i choose "country" filter. but for my "year" filter i want to be always 2011 and 2009 but i can't specifie directly the year in my set analysis because over the time i can have other year!

Do you have any suggestion for me to resolve this problem?

Tks

[Anonymous]

Hi

     Try like this

=sum({$< Year=,

Month=,

Years ={$(=Max(Years))}>}Quantity*Price)

Modified the field which i mentioned in bold and use your filter field in that place except the Country and try it

Hope it will helpful

Regards

Ashok

[#4]

Thank you for answered,

but your answer give me the same things that me.

my formula:

=sum({$<Years ={$(=Max(Years))}>} Quantity*Price) represente 2011 turn over

but if i choose year filter 2010 i would have turn over 2010

concretly the answer what i want:

=sum({$<Years ={2011}>} Quantity*Price)

with this formula even if i choose in year filter 2010 i would have turn over 2011

The probleme is that i don't want specifie{$<Years ={2011}>} because in the futur i will have more year and i will always take the MAX year

Here is my problem!!

Tks

Stéphane Vinoth pelerin

[CELAMBARASAN]

Hi,

     Change this expressions

=sum({$<Years ={$(=Max(Years))}>} Quantity*Price) = 10000€ (turn over for all country) represente 2011

=sum({$<Years ={$(=Min(Years))}>} Quantity*Price)= 9000€ (turn over for all country) represente 2009

to

=sum({$<Years ={$(=Max({1} Years))}>} Quantity*Price)

=sum({$<Years ={$(=Min({1} Years))}>} Quantity*Price)

Celambarasan

[CELAMBARASAN]

Hi,

     You can also use

     Max(ALL Years) and Min(ALL Years) because both are same.

Celambarasan

[#7]

Tks Celambarasan,

you are great!!!