It would be nice if QBO shared the frustration

I have tried using a pivot table but  because the QBO transaction reports dont fill in the columns

Yout have

Sales

  Wellie Sales

               xxxx - cccc- fffff

               xxxx - cccc- fffff

               xxxx - cccc- fffff

Wellie sales total      XXXX

and it doesnt work

Ah well