Needing Excel help, kind of.
Mar. 8th, 2014 04:25 pm![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png)
Excel and/or businessy-talented people, would you help me, please?
I have a table that I need to sort in order to "[d]isplay subtotals for sales by year, month, and territory." There's also a product category not mentioned, but when omitted makes for a very messy table.
How would you interpret that directive (with the assumption that it needs to remain one table)? There are two years, three territories, and five product categories. Would you make separate columns for the years (and maybe territories), then sort from there?
I know how to sort and subtotal; it's just I'm having a very difficult time visualizing what the final table should look like, and so having a difficult time figuring out what levels each section should go on.
I have a table that I need to sort in order to "[d]isplay subtotals for sales by year, month, and territory." There's also a product category not mentioned, but when omitted makes for a very messy table.
How would you interpret that directive (with the assumption that it needs to remain one table)? There are two years, three territories, and five product categories. Would you make separate columns for the years (and maybe territories), then sort from there?
I know how to sort and subtotal; it's just I'm having a very difficult time visualizing what the final table should look like, and so having a difficult time figuring out what levels each section should go on.