how to write an expression in pivot table without change its values by selecting any selectors

[venkat1]

Hi all 

i have a pivot table and year selector,if i select the year selector then in pivot table outstand fields are changing to zero, i had used set analysis but does not  work,my requirement is to show static values for that field,can anyone know how to do this?

[Gysbert_Wassenaar · Accepted solution]

Change all the measures that you use in the pivot table. Change for example sum(Amount) to sum({1} Amount). The {1} part will make the measure ignore any and all selections the user makes.