Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have created a pivottable, where the columns represents customers within a selection (dynamic).
In every colum i want a expression (sum of values with certain criteria) for that particular customer.
In current version it calculates the sum over all customers because the column (clientnr) is not a selection.
Any ideas ? Am a reel beginner and searched a long time on the forum, but didnt find a simular situation.
I attached a screenshot. The red box represent the total value, but i want that value related to the customer in de column.
Current formule in the variable is:
= Sum( { $<strGrootboekGroupCode= {"HC.1.*" }>}lngGrootboekSaldo)
I'm looking for something like:
= Sum( { $<strGrootboekGroupCode= {"HC.1.*" }>,<Clientnr_=Columnheader>}lngGrootboekSaldo)
Ofcourse the second is not working, only to clearify what i want to achieve
Any help?
Unbelievable......i spend hours on trying....you have the solution in a few minutes!
I'm jealous at your qlikview-knowledge!
Thanks again!
No problem at all, I am glad I was able to help and make you feel a little jealous