Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello got a pivot table showing the open amount for each customer
and in another column I want to show the cumulative amount
the cumulative amount I'm using Aggr with sorting but it is not working properly
check attached document and advise please
as the cumulative amount should start with 82.5 and so on...
which QV Version are you using?
I'm using qlikview 12
Is this you are expecting on your chart?
check attached document and help please
I'm using Aggr with sorting but it is not working properly
You have neither explained what isn't working in your post, nor have you mentioned anything in the attached qvw. What is not working properly? You need to point it out, else we will just be doing a lot of guess work
I've checked and i gave some inputs. Are you looking for that? Or you may need to show where it is not working as sunny suggested.
the cumulative amount is not working properly
see in the screen shot and the document attached
the cumulative amount should start with 82.5
the cumulative amt should start witn 82.5
so there is something wrong in the Aggr function's structure parameter that I'm supplying
Please advise
Since you are sorting by accounting_document_number, here is the sort order
17000010 is 1 followed by 17000011 followed by 17000198 and so on...