Expression variables in pivot table

[Anonymous]

Hi, I've replaced hardcoded expressions in a pivot table by variables which are loaded during script run (SET ...). Works well. Except that when I now expand my pivot table from the 1st dim to the 2nd dim, the values for the 2nd dim items are the same (totals). This doesn't happen when I hardcode my expressions. Then I see the different values for both items within the 2nd dim. When I look at the variable values from the menu they are exactly the same as the hardcoded ones. But being handled differently in the pivot table? Any ideas... Thanks, Sander.

[Anonymous]

Hi, added an example. Some advice on syntax in this case or other solution? Regards, Sander

[lironbaram]

hei

attach is your file with what you want

look at the script i changed it a little bit

an also in the pivot table expression

in general when you want a varaible to calulte the formula in the the table the varaible formula need to be aith out "=' sign

when you use '=' sign in varaible the application calculte the varaible on all the data and return a number not a formula

[Anonymous · Accepted solution]

Hi, perfect! Thanks again for your help. I'll keep this syntaxing in mind. Regards, Sander