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]

Pick Dim method is sort of a hack that you need to use because QlikView doesn't have a direct way of dealing with this kind of problem. The goal is to have multiple dimensions with just a single expression. In your case, this will be the values for Dim

and Year will have a condition for the last column.

Does that make sense?