5 Replies Latest reply: Jan 14, 2013 10:27 AM by Gabriela Morales RSS

    Multiple Dimensions

      Hi,

      I would like to add a table where I have 2 summary fields as expression (total value for example). In the dimension I want the top line to be Total and the second line to be the total where a certain criteria is met. What is the best way to achieve this?

       

      For example

              

                     sum value

      Total           2500

      with criteria 1800

       

      many thanks

        • Re: Multiple Dimensions
          Mohit Sharma

          can you attached your sample file...

          i didnot get you exactly

            • Re: Multiple Dimensions

              Hi, many thanks for your help. The raw data looks like:

               

              number       criteria1  criteria2

              acnumber1     1          0

              acnumber2     0          0

              acnumber3     0          1

              acnumber4     1          1 

               

              what i would like to show is the number of accounts that meeti criteria1 and the number that meet criteria2 and the total in a straight table.

               

              My dimensions would be the criterias and only count the account number where this is met. I have set up a flag for this criteria so it shows as 1 or 0, I would like to summarise this data as below:

               

                            number of accounts

              criteria1

              criteria2

               

               

              please let me know if this does not make sense.

              • Re: Multiple Dimensions

                Hi, many thanks for your help. The raw data looks like:

                 

                number       criteria1  criteria2

                acnumber1     1          0

                acnumber2     0          0

                acnumber3     0          1

                acnumber4     1          1 

                 

                what i would like to show is the number of accounts that meeti criteria1 and the number that meet criteria2 and the total in a straight table.

                 

                My dimensions would be the criterias and only count the account number where this is met. I have set up a flag for this criteria so it shows as 1 or 0, I would like to summarise this data as below:

                 

                              number of accounts

                criteria1

                criteria2

                 

                 

                please let me know if this does not make sense.