Help with items that have the same value

[educastri83]

Hello Community!

This time I need your help to identify when:
* in a mobile line there are more than one discount, which have the same discount value but with different revenue code.

Something like this case:

At least at this time I am not interested in cases when the discounts have the same value and revenue code.

I put the base files and the test qvw.

Thanks for your support.

[Frank_Hartmann]

Is this what you are trying to achieve?

Backgroundcolorexpression:

=if(Aggr(NODISTINCT count(Revenue_code),phone_number) <> 1 and aggr(sum(Amount),phone_number,Revenue_code)=aggr(above(sum(Amount)),phone_number,Revenue_code), lightgray(),)

hope this helps

[Brett_Bleess]

Eduardo, did Frank's post help you get things working as you wish?  If so, please use the Accept as Solution button on his post to give him credit and let others know that it did work.  If you are still having issues, please provide an update.

Regards,
Brett

[educastri83]

Thanks frank, almost.. but it can work for me.

How can I do so that only the table only shows the records where the background turns gray, that is, it does not bring the entire pivot chart, only for cases where the condition applies.

[Frank_Hartmann · Accepted solution]

see attached

hope this helps

[educastri83]

Thanks Frank! it works