Can I have main group count and subgroup count in Tree Map

[sahilhira162]

Hi

I have created a tree map for project count data which are grouped by Division wise and then subgroups by departments. I am getting count label by department i.e. subgroup wise. I want the count for main group as well. I have looked around but couldn't find any option. Please let me know, if there is a way where we can put count to the main group as well.

PFA screenshot for the same. I want the count for each division as well, division 1 count i.e. (sum of all dept in division 1) and similarly for all the divisions.Need count for each division as well. I am getting count dept wise only.

Thanks in advance.

Regards,

Sahil

[v-jiascu-msft]

Hi @sahilhira162,

Please share a dummy sample.

Best Regards,

Dale

[sahilhira162]

@v-jiascu-msft @Greg_Deckler

PFA screenshot of exported dat

[sahilhira162]

@v-jiascu-msft @Greg_Deckler

Is it not possible to get the count both by group wise and subgroup wise. I have attached report and exported data  as well.

Kindly suggest the same.

Regards,

Sahil

[v-jiascu-msft]

Hi Sahil,

It's hard to display two groups at the same time. Maybe you can add them in the group, then you can switch between two groups.

Best Regards,

Dale

[Greg_Deckler]

Can you share some sample/example data so that we can see how it is currently organized?