Formatting on Drilldown Dimension

[drewjamison1396]

I am trying to format my vender cells to be red if any sum(margin) in the drill down are negative values. So that if even the total sum(margin) is positive for the vender over all, one could quickly isolate any unprofitable products.

the drilldown dimension is as follows

VenderName

ProductCategory

ProductSubcategory

ProductModelName

[lironbaram · Accepted solution]

Hi,
You should use an expression like this:

if(sum(aggr(if(Sum(Margin)<0,1,0),ProductModelName,VenderName))>0,red())

[drewjamison1396]

Perfect!