Alternate State and Table Expression Total

[mmilani12]

 

 

 

Hi I have an issue with alternate state.

I need to show the table expression total on the top of the table (not pivot) but:

- if I use the formula Only({State1}ItemPrice)*Quantity  it does not show the expression total on the top of the table (blank)

- if I use the formula Sum({State1}ItemPrice)*Quantity in the expression total it shows the sum of ALL the ItemPrice without consider the dimensions selected.

I think I need the equivalent of the $ for the set modifiers... Is there anything I can do?

Thanks

[Vargas85]

It can also be used to tie a measure to a state in the expression. To find the total value in State1 the syntax would be: sum({State1}Value).

NJMCDirect Ticket Pay