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
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies