Average formula in pivot and Total average
Hi!
I have 2 questions:
1) I want to add a widget with secondary value of AVG.
Ex:
Store 1: 50000
Store 2: 23000
Store 3: 10000
The average revenue here is 27000
So I want to show the next value 50000 (up 92%), because it is 92% better than the average 50/52
How do I do that?
2) I want to use Avg in my calculation in pivot table, like instead of show total sum, I want it to show total average of the column. And then I need to add a formula of calculating the % of each value from the average. See ex below
|
|
% of total |
% of average |
| Store 1 |
50000 |
18% |
127% |
| Store 2 |
43000 |
16% |
109% |
| Store 3 |
24777 |
9% |
63% |
| Store 4 |
54666 |
20% |
139% |
| Store 5 |
37777 |
14% |
96% |
| Store 6 |
25788 |
9% |
66% |
| Average |
39334.66667 |
|
|
| Total |
275342.6667 |
|
|
|
|
|
|
Thank you in advance!