Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
i want to use a conditional formatting on the font color in a Pivot table.
The Pivot table got two dimensions actual delivery date and planned delivery date and the measure is quantity.
The date fields should be shown as month and if the the month of actual delivery date is greater than the planner delivery date the measure should be shown in red.
Everything works fine, when i do this on calday. But it doesnt work for month.
I generated the month by using num(month(date datefield)) and it shows me the number of the month. But the font color does not fit.
Do i have to group the measure also on a monthly base within the measure?
Thanks for your help.
Regards Jan
@JanM1711 Could you please provide us some sample data and the expected output so that we can figure out some solution for it?