Sum in a pivot table

[sebastian_marti]

Hi, in a pivot table I have one field with values 1, 2 and 3.

I want to divide one amount field by SUM(amount) when field value = 1, for each value (1,2,3).

Description	Totals	% Sales
Sales	1000	100%
Cost	500	50%
Other Cost	200	20%

Thanks in advance

Sebastian

[sunny_talwar · Accepted solution]

May be this

Sum(Value)/Sum(TOTAL {<Description = {'Sales'}>} Value)

[sebastian_marti]

Wonderful!

It's works!

Thank you

[sebastian_marti]

In a pivot table, "Totales" column is the total amount of Account. % Sobre Venta is Totales divided by Totales when Account = "Ingresos".

When two years are choosen, the % value is distributed across each year, example: in "Ingresos" line, % values are 16.84% and 83.16%, both sumarized values totals 100%.

I need that each value represent the % belongs its year. In this case, both column must be 100% (100% for 2017 and 100% for 2018).

The table looks like this:

I really appreciate your support.

Best regards,

Sebastián Martínez

[sunny_talwar]

Then try this

Sum(Value)/Sum(TOTAL <YearField> {<Description = {'Sales'}>} Value)

[sebastian_marti]

It works!!!

Thanks a lot!

[sebastian_marti]

Dear Friend,

I need your help one more time.

I got this problem. I made a difference between two years but i want to show the measure in the end of the table.

I need this solution: (paint)

Please help me!

[sunny_talwar]

May be approach it like this

Chart Expression | Qlik Community

[sebastian_marti]

Hi Sunny, in that link you included one file called "GSD_Value_Scorecard_v1.qvw" but is impossible to open it.

Could you explain in simple words how it works the function/formula?

Thanks,

[sebastian_marti]

Isn't work because the colum still appear in 2018.