I have a Tableau dataset with these fields:
- Manager
- Family Name
- Client ID
I’ve already managed to create a view that lists the top 10 family names by client count for each manager, like this: and I need help on the below insert a subtotal row for each manager - the subtotal should give top 10 total rather than overall total ..i tried several methods it is giving overall total ..please help
Manager | Family Name | Client Count
--------+-------------+--------------
A | Smith | 50
A | Johnson | 42
... (up to 10 rows)
B | Patel | 60
B | Kumar | 45
... (up to 10 rows)
Now I’d like to insert a subtotal row for each manager, summing only those top‑10 family counts. For example:
Manager | Family Name | Client Count
--------+-------------+--------------
A | Smith | 50
... | ... | ...
A | (Subtotal) | 420
B | Patel | 60
... | ... | ...
B | (Subtotal) | 500
Hi, @smanth kumar
Are you looking for something like the attached? Please have a look.
(I’ve tried to express your issue using Region and SubCategory.)
Compare it with your content.
<sample>
*If you get the best results from this exchange, I would appreciate it if you could choose the best answer or upvote.
