topic Re: Formatting on Drilldown Dimension in App Development

Formatting on Drilldown Dimension

drewjamison1396 — Wed, 25 Aug 2021 15:33:43 GMT

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

Re: Formatting on Drilldown Dimension

lironbaram — Thu, 26 Aug 2021 06:06:49 GMT

Hi,
You should use an expression like this:

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

Re: Formatting on Drilldown Dimension

drewjamison1396 — Mon, 30 Aug 2021 15:58:13 GMT

Perfect!