Varaibles in Set analysis

[kinjal1645]

Hi,

I have below expressions:

vBucket = if(($(vsumA) < $(vA_hurdle) or trim(len($(vsumA))) <=1) and ($(vsumB) < $(vB_hurdle) or trim(len($(vsumB)))<=1),  'Low Low',
if(($(vsumA) < $(vA_hurdle) or trim(len($(vsumA))) <=1) and $(vsumB) > $(vB_hurdle),         'Low High',
if($(vsumA) > $(vA_hurdle)         and ($(vsumB) < $(vB_hurdle) or trim(len($(vsumB)))<=1),  'High Low',
if($(vsumA) > $(vA_hurdle)         and $(vsumB) > $(vB_hurdle),         'High High'))))

vsumA = sum(A_num)/sum(A_den)

vsumB = sum(B_num)/sum(B_den)

I want to show following summary: count, vSumA and vSumB for each bucket

This summary shouldn't change based on user selection. 

I tried multiple things but couldn't find any solution.

Kindly help!

@sunny_talwar @swuehl @tresB @Gysbert_Wassenaar 

Thanks

[sunny_talwar · Accepted solution]

This?

[kinjal1645]

Thanks Sunny 🙂