Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a pivot table where I indicated the some margin values to be given in some colors. This is measure in my case. But I need to create filters for the pivot table explicitly within particular range say for example <25 to be red color like that. Is that possible?
Yes, that's possible. You can specify that you want to use an expression to calculate the background color of the column. You'll need an expression like:
If( ...value... < 0.25, LightRed(), if( ...value... < 0.75, RGB(255,128,0). LightGreen() ))
Change ...value... with the field or expression that calculates the values you see as percentages in the column.
ya this I got. But unlike Bar chart can i create legend like for pivot table using some other options available?
Hi,
You can describe coloring logic using Footnote property of pivot object - this is simple idea but pretty logical. You will find footnote in properties of pivot object under Apperance -> General -> Footnote. Example below.
BR,
Milosz