4 Replies Latest reply: Feb 16, 2015 12:33 PM by Agis Kalogiannis RSS

    "share" expression in a chart

    Ronit Kanfi

      HI,

       

      The data I have is a product, its sales in each quarter and year.

      One bar-chart tells me each product sales in each period - sales.

      In the second bar-chart I wish to show the share of each product.

      I have tryed with the expression "sum(sales)/sum(all <quarterinyear >sales)" and marked the field of relative.

      As long as I choose only period of time, it gives me the correct percentage.

      However, if I choose only one product - it gives me 100%.

       

      I have attached the data and desired results as shown in excel.

      How can I fix the expression to get the correct result?

       

      Thanks,

      Ronit