12 Replies Latest reply on Jan 29, 2019 2:13 AM by Prakash Sethy

    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"