4 Replies Latest reply on Nov 8, 2012 2:55 AM by June zeng

    Unique Count & Sales Growth

    June zeng

      I need created a simple report to  show sales growth and unique count of active partners, the definition of active partners is the partners whose current year sales is positive.

      In the sales data set, one partner may sale in multiple states, so in the report, if the partner has positive sales in the state, should be counted as 1 active partner, if not, can't be counted as active partner.

      at the same time, the report need show sales growth(current year compare to last year) by state, the sales growth should be calculated by including all sales in the state(positive and negative).

       

      I have attached my report created by using testing data, the NoFilter tab reported correct sale growth%, the Filted tab reported correct No.Of Active partners, can some one help to showed them in one report?