Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
ReneeWu
Contributor II
Contributor II

filter by pivot table cell color

Hello all,

I just want to select all red or green . If I can filter by cell color in QV ?  

ReneeWu_0-1606727363985.png

 

1 Reply
chrismarlow
Specialist II
Specialist II

Hi,

I don't think you can do this directly (but always happy to be corrected!), but you could do it indirectly, either in a second visualisation that just shows the relevant rows or using variables that limit what is shown in the pivot depending on values (both approaches involve unpicking  the formula/thresholds that have driven the colouring on your pivot).

Cheers,

Chris.