
In this example, I would like to calculate Column 2 mean based on mean of each Group. Group 3 has two values, and the mean of Group 3 should be 6. So column 2 mean based on Group should be (3+3+6) /3 = 4.
When I use Tabulate to get the statistics, each individual subgroup value from Group3 were used separately for calculating the mean.

How to get the correct by Group mean?
Thanks