Selection different color

[Anonymous]

Hi community,

Do you know how to change color for selected tag in Pivot table?

Or maybe show only this tag. I'd prefer highlight the tag.

Thanks,

[jpapador]

What do you mean by selected tag, do you mean change the selection color from green to yellow, or change the background color.  If it is background color, try the following.

In your expression editor, hit the plus sign on your expression and in the background color area use:

if([Purpose of Visit] = 'Make Purchase', Yellow())

You can also do this on the Purpose of visit field on the dimensions tab.

[Anonymous]

I want to dynamically change color, not only for expression.

[jpapador]

What are your conditions for determining the change in color?

[Anonymous]

When user clicks on a row representing a POV. What he selected, that should change color

[jpapador]

Do you have a sample file?

[#7]

Got it, a partener teach me how to do this, look in your expresion in the part of the set Analysis i used this:

Sum({$<[Carrier Group]=>} [# Departures Performed])

This expression I used to say that the selected fields remain intact. Due to th e following "[Carrrier Group]="

You have a table where you want the results to be colored only,in this case Yellow.

Now to get colored the background in the same expresion go to "BackGroundColor" and use somethig like this :

if((Sum( [# Departures Performed])) > 0,Yellow())

In my case only work with [Carrier Group] ,because it's the only one assigned in the "SET ANALYSYS".

Good luck, sorry for the bad english!

Regards.