Please go through the attached document, hope this helps you.
test.qvw 122.0 K
I tried your solution and in the provided scenario it works.
However when implemented with real data I do of course have dimensions such as Customer, Product, etc. In this implementation the total running 12 weeks for each customer is the same as the total for all customers. Adding to the variable `customer.name=` only helps when an actual customer is selected and thus no cross customer comparison is possible. Is there a work around for this so that it works flexible with dimensions?
Thanks and regards,