limit a table dimension

[jheasley]

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?

[#2 · Accepted solution]

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)