Tania has attended:
Excel Intermediate course
Excel for Finance Professionals course
Excel Advanced course
Microsoft Excel
I have a very large database sheet with lots of rows for many invoices and some of the expense can be capital or expense.
The sheet contains many titles such as PO Number and description. A PO Number can cover many invoices.
I tried to create a pivot table so as I could analyse the data easier. I brought in US Dollars as that is the currency that I use. The pivot table brought in lots of blank lines under each with the total of the US Dollars on every line.
How do I ensure I get a good pivot table with not lots of blank lines with just the sum of US Dollars on.
Please can you email with a step by step to do it as I am really struggling and I have spent so much time trying to do it?
I really appreciate it.
RE: Microsoft Excel
Hi Tania
Thank you for using the forum to ask a question.
When you click into the Pivot Table, you get 2 Purple Contextual Tabs along the top, Options and Design.
If you click on Design you have the option top left “Subtotals”.
If you click on this and select “Do not Show Subtotals” it will remove the totals under every line.
If this doesn’t work, please send the file to forums@stl-training.co.uk and I will look at exactly what’s happening, then I can offer step by step assistance (Please keep the original and send a copy).
Kind regards
Richard Bailey
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
