ignoring selections in set analysis

[grajmca_sgp123]

Hi,

I would like to ignore selections (made in a list box) for expressions used in my pivot table.

I used following expression in the table for Max Year:

MaxYear expr:

sum({< Year = {$(vMaxYear)},Year = ,Quarter = ,Month = >} Sales)

Previous Yearexpr:

=sum({< Year = {$(vPreYear)},Year = ,Quarter =,Month = >} Sales)

above two expr have different data for max year and previous year but I am getting same values for both years.

If we remove ignore conditions(Year =,Month 😃 the Values are correct but i am unable to ignore the selection.

i have attached one sample app for your reference.

[grajmca_sgp123]

Thanku,Yes I agree with you,I want to ignore selection on years also but not working??can you explain why its not possible on Year??

[maxgro]

to ignore Year

sum({$ <Year =>} Sales)

to ignore Year and Month

sum({$ <Year=,Month=>} Sales)

if you want the total sales within the application, disregarding the selection but not the dimension

sum( {1} Sales )

or something else?

Set Analysis: syntaxes, examples