Change the selected row color as green in pivot table

[udaya_kumar]

Hi,

i have a pivot table with data, when we select some row, then that row should be highlighted with some color.

i tried it with background color property in table for dimension and expression, its not working.

so how we can do that?

[udaya_kumar · Accepted solution]

hello experts,

i did it by using the expression

=if(wildmatch(GetFieldSelections([trend.Product],',',100),'*'&only({1} [trend.Product])&'*' ),RGB(255,0,0))

it works fine,

put this in background color property for dimension and expression.