ingore user selections for graph

[#1]

is there a way to ignore the user selections form the list boxes on a graph?

i have two graphs, the first graph i want updated based on user list box selections (Month\Year) and the second graph i want to be fixed i.e. shows all data for years 2009-2010 + 2010-2011irrespective of user Month\Year list box selection.

I have a feeling this is done by set analysis but there isnt much guidance on set analysis at present.

see image for exampleof both graphs as they are at present (both are updated byuser Month \ Year selection)

[john_duffy · Accepted solution]

Hello.

You can use set analysis to accomplish this. An expression such as SUM({$<YYYYMM = {"*"}>} SALES) will sum SALES, ignoring any selections in a list box for YYYYMM.

[#3]

hi john,

thanks for your soultion it worked fine.

The expression i used was:

COUNT({$<YEAR = {"*"}>}[SALES])

Do you also know how i could adapt this expression so that it includes all MONTH aswell??

I was thinking COUNT({$<YEAR = {"*"}>}[{$<MONTH = {"*"}>}SALES]) but this doesnt work

[john_duffy]

The syntax would be: COUNT({$<YEAR = {"*"},MONTH = {"*"}>} SALES)