when selecting customer - see all amount for main customer

[idogridish2]

Hi All,

when i am selecting Customer Name i want to see whole amount for main customer name,

what is happening:

that is how qlikview is working - i know.

what i want:

many thanks.

Sample attached.

[sunny_talwar · Accepted solution]

Try this:

Sum({<[Customer Name], [Main Customer Name] = p([Main Customer Name])>}Amount)