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?
