Dashboard - Display datas in a pivot table with a defined status

[Mouna_Felah]

Hi there,
I want to ask if it is possible to show datas in a pivot table with a defined creteria.
I tried to do it with rules but it is only for color or adding icon ...
Is there another way to display attributes 1 when attributes 2 = 'VALUE' ???
I can't use a request SQL because, in the same Dashboard i have to show many cases ....
Thanks in advance for help,
Mouna,

[Todd_Bailey]

Mouna,

Thank you for your question.  Every dashboard item has the ability to have a filter added on the client side.  You will need to go to the Data > Edit Filter from the menu.  If you are working with a Pivot table, all columns, rows, and hidden dimensions can be used to filter the data out.

Thank you,

Todd Bailey

[Mouna_Felah]

Hey Todd,
It mades my day !! That's what i was searching for !! Thank you for helping me.
Mouna,

[Lood_Strydom1]

Hi Todd & Mouna

I'm sure you could do it with a calculated field?  Surely the filter will just filter out lines where, in Mouna's example, Attr2 = "Value" (as an example).

Just an idea . . .  [emoticon:c4563cd7d5574777a71c318021cbbcc8]

Regards, Lood