I have a report that has been working well with just "Master Account...", "StockCode" & "Name" as options in the pivot table. As soon as I added "SalesCategory" I found a strange issue that I cannot solve. Under the Rebates & Discounts column the total for "SalesCategory" is nil despite everything below is calculating fine.
The fields under E-Commerce and Gross sales have been blanked out for posting but are populated correctly with values. This includes the one rebates value that is blanked out too.