Fixed sum in pivot table

[#1]

hello all,

I fell I am this " " close to make it work but it seems that the below expression won't

You see, I want to always get the sum of the SALES field for the year 2012 of YEAR field regardless the what is the selected year. The rest of the fields (CUST, PROD, etc) may vary and affect the outcome. According to the Ref Manual this should be working... but it isn't

sum({1<YEAR={2012}>}[SALES]

)

what did I miss?

thx

[lironbaram]

hi the expression you wrote is disregarding all selection in the model

you should try

sum({<YEAR={2012}>}[SALES]

)

[#3]

hello Lirin, same thing, it returns the value only when 2012 is selected for the rest I get 0

[lironbaram]

can you post sample data

[#5]

here is the lay out,(data is scrabled)

[#6]

...sorry for my previous message, just saw that the attachement wasn't there, here it is

H

[Anonymous · Accepted solution]

Hi,

  Please find the attachment of application,sales will be display for max year=2012

and reatil and service will be change according to year selection.

Regards

[#8]

great, thanks!