I am trying to create a temporary pick list for our warehouse whilst we change systems. My dimensions are Supplier / Order Number / Product / BBE / Pallet ref / Location (there are others but not that affect this I don't think).
Expression is Quantity (on each specific pallet).
We have a lot of pallets for the same product, so I want it to just suggest 10 pallets for them to choose from based on the oldest BBE.
I am currently using this calculated dimension in a pivot table:
You want to Rank by BBE, but you want to Rank, sum(Qunatity), right? What you are ranking has the same value. I feel like I am not 100% sure I understand your issue. I can continue to help, but I hope someone else who understand your issue might be able to help you better here.