On the attach qvw you will see a very simple scenario. Sales of 5 or 6 products to 2 customers. I need this sorted by the best customer and then per customer by the best products. You will see the sales total by product by customer and the running percentage for each product for each customer. I need to report back the accumulated running percentage.
For the sorting I had to create a sort by rank in a column whose text is white and is very narrow. it has the ranking for each product for each customer.
How can I create the accumulated running percentage that initializes at 0 on every new dimension 1 change?
Attached qvw and xls with the desired resultant.
Thanks for your help!
