Dear visitor, despite all the challenges, our team continues operating at full speed.

We are ready to help with any questions you may have. Please fill out this quick form and we'll get back to you.

Fill the form
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 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:
Hope it helps.

Please login or Register to Submit Answer