Extra Level in excel outline

%3CLINGO-SUB%20id%3D%22lingo-sub-2440109%22%20slang%3D%22en-US%22%3EExtra%20Level%20in%20excel%20outline%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2440109%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20an%20additional%20level%20of%20granularity%20in%20an%20excel%20outline.%26nbsp%3B%20Can%20I%20subtotal%20on%20more%20than%20one%20column%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%20I%20am%20pulling%20a%20subtotal%20by%20company%20for%20all%20products.%26nbsp%3B%20I'd%20like%20to%20get%20product%20subtotals%20too.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2440109%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2440457%22%20slang%3D%22en-US%22%3ERe%3A%20Extra%20Level%20in%20excel%20outline%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2440457%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1076895%22%20target%3D%22_blank%22%3E%40Andrewattheshore%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EWithout%20a%20decent%20excel%20file%20(without%20sensitive%20data%2C%20please)%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3Ewhere%20you%20can%20explain%20your%20plans%20in%20detail%20based%20on%20this%20file%2C%20it%20is%20very%20difficult%20to%20follow%20you.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EThe%20translation%20is%20not%20always%20correct.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EOf%20course%2C%20knowing%20the%20Excel%20version%20and%20the%20operating%20system%20is%20an%20advantage%20for%20everyone.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3ENonetheless%2C%20I%20am%20sending%20you%20some%20examples%20via%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fsubtotal-function-7b027003-f060-4ade-9040-e478765b9939%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3ESUBTOTAL%3C%2FA%3E%20in%20a%20file%20(and%20as%20a%20Link%20for%20Info)%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3Ewhere%20you%20can%20add%20your%20own%20data%20if%20it%20suits%20you.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20Community%20members%20reading%20here.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I need an additional level of granularity in an excel outline.  Can I subtotal on more than one column?

 

For example I am pulling a subtotal by company for all products.  I'd like to get product subtotals too.

1 Reply

@Andrewattheshore 

Without a decent excel file (without sensitive data, please)

where you can explain your plans in detail based on this file, it is very difficult to follow you.

The translation is not always correct.

Of course, knowing the Excel version and the operating system is an advantage for everyone.

 

Nonetheless, I am sending you some examples via SUBTOTAL in a file (and as a Link for Info)

where you can add your own data if it suits you.

 

I would be happy to know if I could help.

Nikolino

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.