PARTICULAR SYNTAX SUM TOTAL {1}

[philgood34]

Hi

i have a table with sectors (named "secteurs") and sales (named "VMS_CATTC")

In the table below you'll see the total sales 2016 for all sectors

As you see the TOTAL 2016 =35444655 , and i trained with different syntaxes using TOTAL or not ...

Now my issue:

several sectors don't produce sales as administration, so if i select administration obviously i have sales = 0

Ok .

for reason of calculation of ratios (in others tables) i need an expression which give the result 35444655 EVEN IF  I SELECT only 1 sector producing or not sales ...

In other words, an expression which give TOTAL SALES OF 2016 regardless of the selected sector ( but with the selection of the year being operational) ... I undertstood that {1}TOTAL expression is not appropriate because of this last point

i thought that with my Sum({<Flag = {'CY'}>}TOTAL VMS_CATTC) it would be correct , as you see above, it is not ...

is there a trick using the syntax ?

thank's in advance

Philippe

[philgood34]

hI BECKI

as master Stephan wrote :

the 1 is to ignore all selections in your model

then Annees = $::Annees allows only years selection

or

with p(), select only year you want to be considered

Regards

Philippe