I have a pivot table. With field 'Buisness' as a dimension. I then have date.month in column with values.
I then have fields which contain reward payments. I have columns called LeadTimeReward and LeadTimeMissed.
What I want to happen is for my table to show the LeadTimeReward as standard, then, if null, return LeadTimeMissed as value in Red Bold font. Can anyone please help?
Assuming there's no aggregation related issues, you could use Coalesce(LeadTimeReward,LeadTimeMissed) as your measure. Your color formula might be if(IsNull(LeadTimeReward),Red()).
