If It is possible,Can you send the .twbx file?
Sreenadha Reddy Palakolanu
Thanks for the quick reply, unfortunately it's client sensitive data, but I will create a data set that will comply with the request / help needed shortly and post here.
Really appreciate it.
Get Outlook for iOS<https://aka.ms/o0ukef>
The table looks osmething like this:
Store Category Product Daily Sales Main Store Dairy Cheese 500 Main Store Dairy Milk 300 Main Store Dairy Cream 200 Main Store Dairy Butter 300 Main Store Consumable Product1 100 Main Store Consumable Product2 1000 Main Store Consumable Product3 2000 Main Store Consumable Product4 3000 Main Store Consumable Product5 1000 Main Store Consumable Product6 3000 Branch1 Dairy Cheese 90 Branch1 Dairy Milk 100 Branch1 Dairy Cream 80 Branch1 Dairy Butter 70 Branch2 Dairy Cheese 1000 Branch2 Dairy Milk 2000 Branch2 Dairy Cream 3000 Branch2 Dairy Butter 1000
I have a parameter on category which once selected, then fetches all the daily sales for that category above 100 and returns the Product for that category. That is Report1.
Report2 should then fetch the same products and display them for Branch1, Report2 should then fetch the same products for Branch2 and display them.
This is the simple version, I actually have the product pictures displaying on the report.
As an example if the person chooses Dairy, then Report1 should return Milk and Cheese (assuming i set the minimum sale value to 300 in the filter shelf) The controlling store is always the Main store. Eveything else is always compared back to the main store.
It should then go grab the same two products for Branch1 and display it in Report2 and the very same product for Branch2 and display it in Report2 regardless of Daily Sales in Branch1 and Branch2
I hope this make more sense now? Please let me know.
Thanks in advnce and best regards