Hi,
I'm trying to create a pivot table that would calculate the data as follows:
My pivot looks like this right now (without the weight)
But item B should have a weight of 2 so the total average of progress should be 70% = (50%+80%+80%)/3.
I can easily calculate this with a excel formula but I want to get this overall average in a pivot table.
Any help would be much appreciated.
Thanks
Fred
I'm trying to create a pivot table that would calculate the data as follows:
My pivot looks like this right now (without the weight)
But item B should have a weight of 2 so the total average of progress should be 70% = (50%+80%+80%)/3.
I can easily calculate this with a excel formula but I want to get this overall average in a pivot table.
Any help would be much appreciated.
Thanks
Fred