Forum Discussion
Solved
Data Aggregation base on dates
Hi there, I want to aggregate purchase quantity base by date and place the result on a different cell. Can someone please shed some light on this. I am attaching the data table and output table he...
Thanks! But I actually need the layout I mentioned in my file. I think I can use your formulas as well.
It's okay,,, but the method used by Lewin is exactly what I've suggested through Test data file,, and the biggest issue was for quantity formula has to use for every column separately, which is not a good practice that's the reason I've suggested another one !!