how to show fixed set of data in a dimension

[Anonymous]

Hi,

My question is simple realy but i havn't found an answer anyware.

I have a simple table with one colum (dimension) detalies the names of my employees, and the second colum (dimension) their status (active, MLOA etc.)

How can i make the table to show only the employees with a specif dimension, without it being impacted by filter and aggreagation options.

I tried set-analyis, but it wotks only with measure.....

Thank you

[arvind1494]

It must be done with the help of set analysis .

Please share your data samples then we will able to resolve this.

[ChennaiahNallani]

try with 'aggr' function

[paola_valenti]

hi,

if you use set analysis in measure expression and specify in the set the desired dimension value, you will obtain exactly what you need in your dimension in the table.

Filter will not impact on that dimension for that table.

[Anonymous]

Can you provide an example please?

[jothimala]

Hi !!

Try this out!!

if(DimensionField='value', Emp_Name_Field)

The value may be the value of particular dimension on which you want to filter

[paola_valenti · Accepted solution]

I was thinking something like this:

if you filter some value, nothing will happen in tables with set analysis.

[paola_valenti]

Here my simple app

[Anonymous]

Thank you !!

This is it

[paola_valenti]

You're welcome!