Hi all, is there a way to remove duplicates? It creates one for every item in a transaction.

Are u using a join in your saved search ?

This is not a saved search it's a workbook in netsuite analytics. I don't have this problem when doing it in a saved search, but I need to make it a pivot table.

Is it the classic "mainline is true" condition you're missing?

The mainline does help in some cases. But I'm starting to believe that analytics isn't well suited for this and I should just do a saved search.