Pivot cell highlight ?

[gerrycastellino]

Is there a way to highlight a cell in a pivot chart  once you click into that cell ?  as indicated below ?

[ashfaq_haseeb]

Hi,

Yes possible

Go to Setting --> user preference --> Design Tab --> Select Always show Design menu items.

Then right click on cell you want to highlight and select Custom format cell. --> apply your required formatting here.

Have a look at below post too

Re: custom row colors in pivot table

Regards

ASHFAQ

[JonnyPoole]

I did get a sample working for this . There are two pieces needed. One expected, one not so much

1. (expected) background color expression on the cell to check if a drill has occurred and which selection was made

if(

  (

  GetSelectedCount(Year)>0

  and

  GetSelectedCount(REGION)>0

  )

  and

  (

  SubStringCount( Concat(DISTINCT total REGION),REGION)>0

  and

  SubStringCount( Concat(DISTINCT total Year),Year)>0

  )

  , LightGreen())

2. ( a little unexpected):  I used SET ANALYSIS to ensure that all values still show after the selection, but it causes some inconsistent selection behavior. The solution was to multiply by an aggregation function that does not use SET ANALYIS but also does not change the result:

sum( {<REGION=,Year=>}  Sales)

*

(sum( Sales-Sales)+1)

[gerrycastellino]

Jonathan:

a good start Thank You !, But  I'm running into issues.

I added the variable as you created, and have my new sheet created.

However when I click on a cell in the pivot,  QV seems to be crashing with the image you see.

Gerry