0 Replies Latest reply on Dec 19, 2012 5:54 AM by Matthieu Geze

    Category exclusion report

    Matthieu Geze

      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.

      Any suggestion on how to tackle that problem?