3 Replies Latest reply: Jul 29, 2016 3:33 AM by PAUL YEO RSS

    QS how to get relative % contribution ?

    PAUL YEO

      Hi All Mr Tamil help me to make reduce the dimension from 8 row to 2 Row.

       

      And my table can have 1 column display sales and another column display % contribution.

       

      In QV we just select relative. it will display % , Can some one share with how to do it in QS ?

       

      Paul

          • Re: QS how to get relative % contribution ?
            arul settu

            HI

            for contribution try with this

             

             

             

            (sum(

            If( US_Cust='USD', 1.3,

            If( US_Cust='RP', 0.0001,

            if( US_Cust='EU',1.5, 1)))* days3)

             

            + sum(

            If ( US_Cust='USD', 1.3,

            If ( US_Cust='RP', 0.0001,

            if ( US_Cust='EU',1.5, 1))) * days6)

             

            + sum(

            If ( US_Cust='USD', 1.3,

            If ( US_Cust='RP', 0.0001,

            if ( US_Cust='EU',1.5, 1))) * days9)

             

            + sum(

            If ( US_Cust='USD', 1.3,

            If ( US_Cust='RP', 0.0001,

            if ( US_Cust='EU',1.5, 1)))*above12)

             

            + sum(

            If ( US_Cust='USD', 1.3,

            If ( US_Cust='RP', 0.0001,

            if ( US_Cust='EU',1.5, 1))) * curren))   /

             

             

            (sum(total

            If( US_Cust='USD', 1.3,

            If( US_Cust='RP', 0.0001,

            if( US_Cust='EU',1.5, 1)))* days3)

             

            + sum(total

            If ( US_Cust='USD', 1.3,

            If ( US_Cust='RP', 0.0001,

            if ( US_Cust='EU',1.5, 1))) * days6)

             

            + sum(total

            If ( US_Cust='USD', 1.3,

            If ( US_Cust='RP', 0.0001,

            if ( US_Cust='EU',1.5, 1))) * days9)

             

            + sum(total

            If ( US_Cust='USD', 1.3,

            If ( US_Cust='RP', 0.0001,

            if ( US_Cust='EU',1.5, 1)))*above12)

             

            + sum(total

            If ( US_Cust='USD', 1.3,

            If ( US_Cust='RP', 0.0001,

            if ( US_Cust='EU',1.5, 1))) * curren))

             

             

            change the number like below

             

            Untitled.png