Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can we interpret below set analysis to add to pie chart calculated dimension as a if condition?
How can we use P() Function in pie chart for calculating?
count({<Quote_Status = {'Lost'},Flag={1},Product=P({<Division={'A&H'}>}Product)*P({<Division={'P&C'}>}Product)>}[Quote Number])+
((count({<Quote_Status = {'Quoted'},Flag={1},Product=P({<Division={'A&H'}>}Product)*P({<Division={'P&C'}>}Product),
QuoteDateDifference={">30"}>-<Quote_Status = {'Lost','Bound'}>}[Quote Number])))
@Saranya1 may be below
=aggr(if(count({<Quote_Status = {'Lost'},Flag={1},Product=P({<Division={'A&H'}>}Product)*P({<Division={'P&C'}>}Product)>}[Quote Number])+
((count({<Quote_Status = {'Quoted'},Flag={1},Product=P({<Division={'A&H'}>}Product)*P({<Division={'P&C'}>}Product),
QuoteDateDifference={">30"}>-<Quote_Status = {'Lost','Bound'}>}[Quote Number])))>0,Diemension),Dimension)