In this case the pivot needs to be sorted in Order of Discrepancy Value an (expression) over the entire set
ie in Order of Discrepancy Value give me a pivot of operator,Branch,seq,Tran,Item etc. There is also a calulated dimension on this pivot filtering only the items in a selected StockTake.
