Compare sales of selected client vs average of all other in the same region, excluded by selection.

[#1]

Hi,

I want to select a specific client, which belongs to a certain region. I want then to compare the sum of this client's sales vs. the average of all clients in the same region (but excluded by the client selection), including himself..

Thanks for you help.

PC

[lironbaram]

hei

try this one

maybe it'll help you