Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I would like to create a measure where I am finding the total for one dimension (or rather ignore another), but also to provide a filter.
e.g. SUM( TOTAL <Dim1>, {$<IsCurrent={'1'}>}, Value)
I am not sure if this is possible, or my syntax is just wrong, but help would be appreciated.
Thanks,
Chris
Hi Chris,
You are almost there.
Just removed commas.
SUM( TOTAL <Dim1> {$<IsCurrent={'1'}>} Value)
Regards,
Kaushik Solanki
Hi Chris,
You are almost there.
Just removed commas.
SUM( TOTAL <Dim1> {$<IsCurrent={'1'}>} Value)
Regards,
Kaushik Solanki
Thanks Kaushik.
I believe, I also found a similar way to do it like the following.
SUM( {$<IsCurrent={'1'}, Dim1 =>} Value)
So setting the Dim1 = no restriction
Thanks again,
Chris