Skip to main content
Announcements
Get Ready. A New Qlik Learning Experience is Coming February 17! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Table pivot- %formula

Hello, First at all, sorry about my english.

I have this pivot table

 

zonavendedorvalor
1a100
b300
2h50
g150
d250

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?

1 Solution

Accepted Solutions
morganaaron
Specialist
Specialist

No worries!

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

View solution in original post

3 Replies
morganaaron
Specialist
Specialist

No worries!

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

Not applicable
Author

Ty !

MK_QSL
MVP
MVP

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)