3 Replies Latest reply on Aug 30, 2018 11:30 AM by edlira.stefani.0

    percentage

    kamran munib

      Hello Folks

      I am trying to create a dashboard with the percentage of total sales but I want it for 1 element in the field. I am getting percent of total for all the values and when I exclude one values the percent changes.(doesn't calculate with total sales)

      If I exclude 'home office' and 'consumer' it should give me this image

      but I am getting this after excluding the other two.

       

      the quarters will change from q1,q2 to 2017/1,2018/1 etc etc

       

      my goal is to get the percentage of each segment by quarter with toal sales.... (segment percentage with total sum of sale) the sum of sales is in sheet 2 of the attachment.

      example in column segment value 'corporate' I want q1 percentage of  with sum of total sales..