Update: Added attachment (PDF)
Disclaimer: Noob in the house. I'll try to phrase the question correctly.
SSRS Picking Report uses dataset in matrix. Data Set is a Pick List with varying numnber of Sales Orders having multiple lines per order. Lines contain Bin location and Item Quantity. Item Quantity is aligned with each corresponding column header(order).
The Orders are grouped in columns which expand dynamically to the right. The Line Items comprise the rows. The Tablix is sorted by the rows (Bin location).
I would like to autonumber, dynamically, the columns (distinct orders). "1" for the first column (order), "2" for the second column, "3" and so on.
I've tried several suggestions online, generally involving getCount in Code, and expression referencing the code. None work. If I have 10 columns, columns are ordered non-sequentially based on logic I'd spin my wheels trying to figure out.
I also tried CountDistinct(OrderNumber).
I'm throwing darts, blindfolded, at this point. One will surely hit me on the head without your help.