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...
Is this you are expecting on your chart?
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