Forum Discussion
OMIT ROWS WITH NO DATA
Hey guys I built a report that shows sales by customer with customers down the left side and months across the top with sales figures. The report pulls every customer regardless of whether they ...
Please share the sample data for better understanding your issue.
If a cusotmer doesn' have any sales in a year eg,2017, is there any record regarding this customer in that year, such as total sales = 0 or total sales is null?
Did you try to use advance filter to exclude the customers without sales info?