How to calculate the average in the pivot table and the straight table.
Consider i have below table.
Marketing Group
Marketing Team
Location
Month
Working Days
A
A1
New York
Jan-11
20
A
A1
New York
Feb-11
18
A
A1
New Jersey
Jan-11
20
A
A1
New Jersey
Feb-11
18
A
A2
A
A3
B
B1
DC
Jan-11
20
B
B2
B
B3
there are marketing team without location but active so i want to show only the Maketing Group and Marketing Team Which is having location and average of working days. i tried to use Avg but it is giving wrong value.
Considering the avg calculation is A= 76/2= 38, but it is taking the avg by location and taking the avg og Marketing team. But it should be sum of Location and avg at marketing team
