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