Home

Pivot Tables

%3CLINGO-SUB%20id%3D%22lingo-sub-481386%22%20slang%3D%22en-US%22%3EPivot%20Tables%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-481386%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20lot%20of%20data%20and%20I%20am%20trying%20to%20Make%20my%20transaction%20amount%20pull%20through%20on%20my%20pivot%20table.%20When%20I%20create%20the%20pivot%20table%20the%20transaction%20amount%20pulls%20through%20as%20a%20subtotal%20for%20every%20individual%20amount%20down%20the%20entire%20column%20for%20each%20account%20it%20is%20the%20same%20number.%20I%20do%20not%20know%20how%20to%20fix%20this%20and%20i%20have%20been%20trying%2C%20researching%2C%20etc%20and%20I%20just%20cannot%20figure%20it%20out.%20Please%20help..Thank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-481386%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-481406%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20Tables%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-481406%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F325762%22%20target%3D%22_blank%22%3E%40Cgibson_2019%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPerhaps%20you%20use%20wrong%20sequence%20in%20rows%20pane%2C%20try%20to%20change%20dragging%20up%20or%20down.%20If%20you%20provide%20small%20sample%20it'll%20be%20more%20clear.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Cgibson_2019
Occasional Visitor

I have a lot of data and I am trying to Make my transaction amount pull through on my pivot table. When I create the pivot table the transaction amount pulls through as a subtotal for every individual amount down the entire column for each account it is the same number. I do not know how to fix this and i have been trying, researching, etc and I just cannot figure it out. Please help..Thank you

1 Reply

@Cgibson_2019 ,

 

Perhaps you use wrong sequence in rows pane, try to change dragging up or down. If you provide small sample it'll be more clear.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies