I am trying to create a pivot table based on this
No. Invoice
Company Net Amount () Infrastructure M&S/Aldi/Retail Safeline
8.13 28/02/2017 Stace 12,000.00 3,050.00 2,155.00 6,795.00
I put company and invoice date in row labels
sum of net amount in values and M&S in report filter, this was the only way I could then de-select the blank lines in M&S

When I choose these options this is what appears
Row Labels Sum of Net Amount ()
Stace 12,000.00
As you can see what I would like is the 2155.00 to show not the line total?