I am trying to use an Analytic workbook vs a saved search for Cash Sales/Invoices/Refunds and Credit Card transaction type. So on a saved search I would just have the Item, Quantity and Amount fields, With the analytic workbook there are plenty of blank lines for amount, and doing Main line false doesn't remove them. Can anyone explain to me what I am missing?

Oh wait, hahah...I see what you mean. Could be shipping/tax lines and such.

maybe add a filter that Amount is not empty or 0?

I will probably end up doing not Null, but curious of why it is displaying blank.

Might have to due with the amount column? Perhaps that's not pulling line amount, but transaction amount?

I am pulling this line for amount.