I'm trying to put the data together to show a pivot graph of how many people have applied (from the new table) and how many existing (open) accounts they have. For example
No of existing accounts, no of people 0, 1 2, 2 3, 1
I've attached the qlikview files for you to have a look but i'm really stumped. I've also attached a copy of what I am trying to achieve in Excel so you can get an idea
Apologies, it's a cut down version of the real thing. For every line in existing that's another account so i guess we could put account number in there if needs be.
.png "Former Employee"){kind=icon}