Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have the following table
I have the store , the date , the item and the inventory qty in a chart. In the column Diff i have the expression
SUM([Inventory Qty]) - ABOVE(TOTAL SUM( [Inventory Qty]))
The result is not correct because substract all the values for all stores for all items one by one.
The result i want to have is the Diff Correct that substract the values only by store , item.
How can i manage this in order to have the results of the column Diff Correct in a chart ?
Thank you in advanced.