I tried this with some work around with sample store data. Attaching workbook for your reference. I m using 10.3
This is what i am able to achieve:
Is it what you need to accomplished.
Sana.twbx 1.2 MB
Thanks Sonali but I don't see the attachment.
Sana open your question in new window.....
Thanks. However I could not open the workbook since I have lower version than 10.3 installed.
Can you please let me know the approach to get to the solution?