Discussion Board for collaboration related to Creating Analytics for QlikView.
how can I sum up the last 3 Orders of a customer?
I tried it with rank-function, but a sum() on rank() doesn't work.
Please see my application in attachment.
Do you have a solution?
Go to Solution.
Well, if you want to keep close to your idea, try this
you need advanced aggregation to embed an aggregation function like sum into another sum.
Hope this helps,
Thanks Stefan, sometimes it's just so easy.