Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, First at all, sorry about my english.
I have this pivot table
zona | vendedor | valor |
1 | a | 100 |
b | 300 | |
2 | h | 50 |
g | 150 | |
d | 250 |
I need a formula to do this:
% por zona
1 a 100 25%
1 b 300 75%
2 h 50 11.1%
2 g 150 33.33%
2 d 250 55.55%
Anybody can help me with this please?
No worries!
Sum(valor)/Sum(Total <zona> valor) - then format this to show %.
No worries!
Sum(valor)/Sum(Total <zona> valor) - then format this to show %.
Ty !
SUM(valor) / SUM(Total <zona> valor)
or
SUM(valor) / SUM(All <zona> valor)
will give you the desired result..
If you want % across the all lines, use as below
SUM(valor) / SUM(Total valor)
or
SUM(valor) / SUM(All valor)