averygoodun42: (snape)
[personal profile] averygoodun42
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.
This account has disabled anonymous posting.
If you don't have an account you can create one now.
HTML doesn't work in the subject.
More info about formatting

Profile

averygoodun42: (Default)
averygoodun42

April 2020

S M T W T F S
   1234
567891011
12131415161718
192021 22232425
2627282930  

Most Popular Tags

Style Credit

Expand Cut Tags

No cut tags
Page generated Jun. 13th, 2025 10:13 pm
Powered by Dreamwidth Studios