11 Replies Latest reply on Dec 8, 2018 11:45 AM by srikanth reddy

    percentage calculation question

    kalyan sravanam

      Hello ,

       

      " What is the percent of total Sales for the ‘Home Office’ Customer Segment in July of 2012? "

       

      this is the question for super store data..

       

      the answer for this query is given as 23.97% but I get it as 5.3456% something like that..  why is that so? can someone answer me pls...

       

      I did like this

       

      1) sum(sales) in the column

       

      2) month(order date) in the row

       

      3) in the filter shelf , I put segment and selected "Home Office"

       

      4) in the Table calculations " percent of total"