conditional formatting in Pivot Table.
Hii, I have pivot table merchant names and sales , now i want to color the top 3 and bottom 3 of sales column , top 3 should be green and bottom 3 should be red . How can i achieve that
Forum Discussion
But i have dynamic filters , like country , bank and month ,
i have kept the country = Thailand and bank as Aeon and month as 2023 October.
the pivot table displays the merchants and sales . then i am following you method and its not working , i am applying filter on merchants to get top 3 and bottom 3 it is not taking the merchants which are displayed after applying the dynamic filters instead of that it is taking among all merchants which are top3 and bottom3
which is wrong.
How do i solve this .
Hi harish ,
Is it working if you disable all the filters applied on filter panel (on right side)?
How did you applied filter to get top 3 and bottom 3? Is it using Ranking filter?
Feel free to reach out if you have further questions, we're always happy to help
Paldi Solutions, Number #1 Sisense Plugins Developer
