SOLVED
Home

Pivot table subtotal

%3CLINGO-SUB%20id%3D%22lingo-sub-365097%22%20slang%3D%22en-US%22%3EPivot%20table%20subtotal%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-365097%22%20slang%3D%22en-US%22%3E%3CP%3Eim%20trying%20to%20subtotal%20the%20Ord_qty%20by%20the%20Type%20(Shipment%20%2C%20Orders)%20as%20attachment%20but%20every%20time%20i%20chose%20the%20Type%20as%20subtotal%20it%20did%20not%20work%20%2C%20appreciate%20any%20help%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-365097%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-365162%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20table%20subtotal%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-365162%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20say%20that%20the%20last%20category%20can%20never%20be%20subtotal-ed.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-365156%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20table%20subtotal%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-365156%22%20slang%3D%22en-US%22%3E%3CP%3EPut%20Type%20on%20the%20second%20place%20-%20first%20all%20groupings%2C%20after%20that%20descriptions%3C%2FP%3E%3C%2FLINGO-BODY%3E
Samer Baskhayroun
New Contributor

im trying to subtotal the Ord_qty by the Type (Shipment , Orders) as attachment but every time i chose the Type as subtotal it did not work , appreciate any help  

2 Replies
Solution

Put Type on the second place - first all groupings, after that descriptions

Hi

 

I would say that the last category can never be subtotal-ed.

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
18 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies