Table pivot- %formula

[#1]

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?

[morganaaron · Accepted solution]

No worries!

Sum(valor)/Sum(Total <zona> valor) - then format this to show %.

[#3]

Ty !

[MK_QSL]

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)