I am trying to put together a report based on a sales files. The file includes product sold to customers by region, and the product are organized in categories.
I am trying to get a report in which the table shows organized by region, the number of account that buy product category A and B, then the one who buy category A but not B, and B but not A. In other words, I am looking for exclusion not just the fact that they buy the item. And show all of this within one table.
The exclusion is feasible by creating a filter on customer using a formula...but I only can do one, and not have several columns with different filters.