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:
But see attached screen shots (sorry new to the forum so not sure how to attach in here.)
The first one is collapsed, just to show you that it is offering me 10 BBE dates.
The second is expanded to show what I mean that it is giving me all the pallets that related to those dates.
I just want it to give me 10 pallets only, not 10 dates.
Ignore the zeros - they won't be there when I set it up properly. So I'd like it to give me the A80012/085 pallet with 108 on, followed by A80012/101, A80012/421 - 436. But actually there are a lot more than that, as there are 20+ per date shown in the first screen shot.
I guess I understand the confidentiality constraints, but can you share some mocked up data and based on that mocked up data what is that you are looking to achieve? Doesn't have to be a full blown app, just need 30-40 rows of data and what you want to see from it?