Hello,
I am doing a cross tab that is supposed to show item sales per month and the average sales for months that have quantities greater than 0, totals, and then the on hand stock.
So far i was able to achieve everything except for the on hand, i have the correct quantitiy coming out of the query(multiple times per item so i need to select max/min) but i am unable to include it with the desired visualization.
Check the attached screenshot for clarification, i need to add the red column just like that

Thanks in advance,
Ashraf