I am trying to do some benchmark data but want to remove the customer I'm reporting on from the overall benchmark data.
I'm doing this by connection to the same database twice.
The first one (the ones the worksheets is based of us) is the Company (Company A) data that I'm wanting to show.
The second contains data from (All Customers) where I'm just pulling in a sales average.
What I want to do is remove (Company A) from the list of (All Customers) so that their own data doesn't factor into the benchmark Sales average.
Can you attach some dummy data? Or you can Create Set to Exclude Company A