Re: Calculating aggr while ignoring some dimensions in pivot table.
Hi Sunny. Close but not quite. I've modified my example to display your suggestions (without the proportion part for clarity). As you can see from the first input table there are 2 people in the apple group, 2 people in the banana group and 3 people in the cherry group. So what I'm hoping to see in this Pivot is:
for every row under the apple group, the 3rd column will display 2 (total people in apple group)
for every row under the banana group, the 3rd column will display 2 (total people in banana group)
for every row under the cherry group, the 3rd column will display 3. (total people in cherry group)