Use of column-value in pivottabel

[intervigilium]

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?

[intervigilium]

Unbelievable......i spend hours on trying....you have the solution in a few minutes!

I'm jealous at your qlikview-knowledge!

Thanks again!

[sunny_talwar]

No problem at all, I am glad I was able to help and make you feel a little jealous