1 Reply Latest reply: Feb 1, 2018 12:49 PM by Sunny Talwar RSS

    Show Quarterly % in Express

    AJAY SINGH

      Hi Members,

       

      I am not able to group the expression in percentage on the basis of quarter.

      I have the scenario given below:-

        

      Quarter(as Dimension)   Sum(expression1)+Sum(expression2)
      $313,962.93
      Q1$36,260.47
      Q1$24,627.60
      Q1$26,368.20
      Q2$27,909.51
      Q2$26,747.78
      Q2$27,576.78
      Q3$25,242.10
      Q3$24,848.75
      Q3$24,820.91
      Q4$23,270.59
      Q4$20,847.45
      Q4$25,442.78

       

      i am having Quarter as Dimension and other as sum of two expression. so the sum ( exp1 and exp2) which total is bifurcate to different quarters which is good.

       

      But my question is , i need the percentage of  each Quarter. like percentage for Q1,Q2,Q3,Q4?

       

      Can any body help me out from this?