Hello,
I have dataset that includes customer number, Item code, and case sold etc. by invoice date.
When I crate sheet and put customer number, item code and year into column and put month into the row and case into text.
I can make subtotal by customer number but sub total number is compiled with all year.
I want to see subtotal and TOTAL total by customer number with breakdown by year.
Can you please give me any idea to achieve this?
5 answers
