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
I am not entirely sure what you mean, would you be able to share a sample?
When I make the KPI (difference between two years) I got a table like this:
But, I need show this table like this:
(This image I edited in paint)
What is the expression you used?
Sum ( {<[Cuentas_EERR]= {1} >} [SALDO]) - Before(Sum ( {<[Cuentas_EERR]= {1} >} [SALDO]))
The difference is correct but the format i dont like it.
I am 100% sure that you need Pick(Dim(... approach to solve this...
Another thread you might be able to check
Pivot table Hide measure column based on dimens... | Qlik Community
And in general the approach is laid out here
Could you help me with this script?
I will appreciate this. Please
I want to... but how? you have not shared a sample
Sunny, in the last picture, columns Totales, % Sobre Venta, must be part of Pick(Dim function?
Which values we must specify in the script for Dim? Year dimension? Other value?
We can't understand the reason to use Pick function for this problem.
Pick function choose a value from a list, which values make up the list?
Thanks a lot!