Hello,
I currently have a table that has:
61,000 Order records associated to a Store Location
49,000 of those Orders are unique
The reason the 49,000 occasionally duplicate is because an Order can be directed to 2-3 different Store Locations.
I have built a Data Page table that:
Groups the order records (49,000)
Then has an aggregation of "Select Count (Discount [@field:Assigned_Store_Locations])
So it will tell me Order #ABC went to 1, 2, or 3+ Store Locations.
Exporting a download this from a Data Page is too large for Excel to open, so instead