# QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

New Contributor

## Partial sum value in a pivot table

Hi everibody,

I need an expression to calculate a partial percentage (percentage on a subtotal) in a pivot table like this:

 Dim1 Dim2 Sum(Value) SumT PartPerc A AA 1 6 17% AB 2 6 33% AC 3 6 50% Total 6 100% B BA 10 60 17% BB 20 60 33% BC 30 60 50% Total 60 100% Total 66

I tried with this SumT expression:

sum(aggr(sum(Value), Dim1))

but the correct value (6 or 60) is shown only in some cells and not in all of them.

Tanks for any suggestion!

1 Solution

Accepted Solutions
Not applicable

## Re: Partial sum value in a pivot table

Hi,

Try with this:

sum(TOTAL <Dim1> Value)

See the attached.

Regards,

Ricardo

2 Replies
Not applicable

## Re: Partial sum value in a pivot table

Hi,

Try with this:

sum(TOTAL <Dim1> Value)

See the attached.

Regards,

Ricardo

New Contributor

## Re: Partial sum value in a pivot table

It works (and il was so easy ...)

Thanks a lot.

Regards