Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.
see attached
hope this helps
Thanks Frank! it works