4 Replies Latest reply: Nov 25, 2009 1:28 PM by mmaa RSS

    Set analyzis in evaluation of product mix

      I'm trying to evaluate mix of products.

      I prepare pivot table with Salesman, Client number, main product group, upper product group and product group

      The idea of mix is:

      there is a percent of value the individual products comapring to the total sales for indivdual client

       


      [Value]/(sum({$<[Product group]=, [Main product group]=, [Upper product group]=>} Total<[Client name]> Value)/1000)


      I put the $ to the expresins because users can change the date of the analysis. But this expressions doesn't work properly.

      Please help

        • Set analyzis in evaluation of product mix
          Miguel Angel Baeyens de Arce

          Hello,

          Are you taking into account that

           

          Sum({$<[Product group]=>} Value)
          means "Sum Value of everything but [Product Group]" (excluding sum of values that correspond to [Product Group] selection)?

          The issue is assign some variable to [Product Group], [Main Product Group] and so. Which variable do you want to assign to those sets?

            • Set analyzis in evaluation of product mix

              the problem is that i need all 3 variable [Main product group], [Upper product group], [Product group]. We have got over few houndred product groups so users need to have a possibility to narrow down them.

              next i need total of value of client name or number - if I skip this i will have total sales

                • Set analyzis in evaluation of product mix
                  Miguel Angel Baeyens de Arce

                   


                  Magda wrote:the problem is that i need all 3 variable [Main product group], [Upper product group], [Product group]. We have got over few houndred product groups so users need to have a possibility to narrow down them.


                  You may then need a listbox so your users can narrow the search by selecting the items you want to show in the listbox. You don't need any set analysis in this case, because you will always get totals regarding your selection. The only meaning I could understand to use set analysis as you mention is to keep some of the [Main product group], [Upper product group], [Product group] regardless your users selection. If you want them to be changed by users, don't use set analysis or set it up with listboxes.