Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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?