I’m trying to create a visual that shows customers, LY Sales, TY Sales and Gain/Loss. My customers are ranked by Sales (top 25, next 25, other) over a 2 year period (TY and LY). When I try to use my filter to see only the customers in the 1-25 rank, the table on the left (below) WITHOUT the Gain/Loss measure displays only those customers (which is good). But as soon as I add the Gain/Loss column, the table will display ALL the customers, regardless of rank.
How can I get the table on the right to display only those customer which I have filtered out?
Sorry, I had to blank out the customers.