Selective columns in pivot tables

Fanta0575

New Member
Joined
Nov 19, 2019
Messages
13
Quite new to excel pivot tables, I am compiling a simple data entry pivot table. Basically I got suppliers in my rows column, dates for my columns and 3 table values. VALUE ARE AS FOLLOWS an invoice total, nett invoice amount and vat paid. Is there a way that I can only display the vat paid and nett invoice amount in the summary totals column without having to see them populate for each date grouping in the table
 

Fanta0575

New Member
Joined
Nov 19, 2019
Messages
13
Just changed to tabular format and it has included my field headers from table data, I think they should make the tabular format should be the standard format
 

Some videos you may like

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

Watch MrExcel Video

Forum statistics

Threads
1,114,328
Messages
5,547,278
Members
410,783
Latest member
sonnny
Top