Hi and thank you for time with my question.

Here's my situation as in the file attached which is explained more carefully:

- I have a list of customer store, and have to classify them in each tier followed by criteria by category based on their revenue. Then I would like to know how many of them in their tier, as well as showing that on a viz automatically (right now I have to do it manually by copying the result and paste into another sheet).

Thanks for any help that I can have, and don't be hesitate to contact me if you have any queries