🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all hot features!
Get Free Trial

Apply Conditional Formatting (colors) on hierarchy member.

Evgeny Alterman asked on August 5, 2019

We have Sales report by countries and some subcategories.
We need to apply formatting on all cells under each country. So that each country will have its special color.
And the main issue, colores have to appear in the exported excel file.
In API I see “hierarchy” and “member” fields but when I try to use then no formatting appear at all. 
Is there any example of usage of those fields?

1 answer

Ian Sadovy Ian Sadovy Flexmonster August 13, 2019

Hello Evgeny,
Thank you for your question.
There was an issue with hierarchy and member properties in the previous version.
We have fixed it in the latest 2.7.12 and here is the sample how it works: https://jsfiddle.net/flexmonster/phxe7anw/
Hope it helps.

Please login or Register to Submit Answer