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
Highlighted
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
Highlighted

@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
Filter complex table to simple table
Sam2009 in Excel on
1 Replies
Excel Table Size in Macro
WayneEK in Excel on
6 Replies
Set Auto Refresh to Pivot Table as Source Data Changes
ratishkp in Excel on
2 Replies
Taking values from certain rows based on data input
Drakerla in Excel on
5 Replies
Problem sorting Pivot Table according to date
MikkoS in Excel on
1 Replies