Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
good afternoon,
I have a table that uses 2 dimensions and a number of measures. Dimension 2 ('Event') only has 2 values, and I want to create 2 independent versions of the table that are specific to the 2 values. how can I limit the dimension to bring back only those 2 values?
Hi
You can use set analysis in your expressions. Something like this
Tabel1
Sum({<DIM1={'VAL1'}>} Field1)
Sum({<DIM1={'VAL1'}>} Field2)
Table2
Sum({<DIM1={'VAL2'}>} Field1)
Sum({<DIM1={'VAL2'}>} Field2)
Hi
You can use set analysis in your expressions. Something like this
Tabel1
Sum({<DIM1={'VAL1'}>} Field1)
Sum({<DIM1={'VAL1'}>} Field2)
Table2
Sum({<DIM1={'VAL2'}>} Field1)
Sum({<DIM1={'VAL2'}>} Field2)