alternete state in pivot

[Anonymous]

hi,

is it possible to use alternete state in expresion ?

exm:

Sum ({$<_Flag={Inv,InvAdel}>}[KG]) ,

i need to copy that column & make possible to user to chose 2 diffirent period for each column.

hope it's clear.

thanks'

yarin.

[stigchel · Accepted solution]

Your example and question are not quite clear, but If I focus on the question whether you can use alternate states in your expression then yes you can, something like:

sum({<Year=[AltGroup]::Year>}Sales)

where AltGroup is the name of your alternate state