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

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

Watch MrExcel Video

Forum statistics

Threads
1,114,664
Messages
5,549,296
Members
410,908
Latest member
Allen P
Top