Excluding values in set expression.

[ganeshreddy]

Hi All,

I have table as shown in below,and PFA

Please help me on wring expression in UI to calculate the opportunity value, 

Exclude the 'Customer' value matched rows to 'opp string' string to get total GWP_GBP opportunity value.

i.e. Opportunity = sum(Exclude the rows from the calculation where 'opp string' includes 'customer' value. So, if anywhere in the pipe separated listed and a single 'customer' appears, the row will be excluded for total oppotunity)

Thanks,

Ganesh

[ganeshreddy]

Thank you Pratyush.

[ganeshreddy]

Hi Pratyush,

Though it is a correct answer i need to show sale amount as well in the report,but we are getting totals in sale amount column,this is because of the newly created dimension (customer2) PFB,

The output has to be like this,

Is there any workaround that we can avoid new dimension?

Thanks,

Ganesh