2 Replies Latest reply: Jun 14, 2017 1:21 PM by Sunny Talwar RSS

    ignore Time dimension on a chart

    Глеб Aitov

      Hi

       

      I have a line chart

       

      Dimension: WEEK

      Measure: sum(Sales)/sum({<week=>}Purchases)

       

      My intention is that the chart shows Sales for the given week, divided by TOTAL purchases which were made, regardless of the week. So, in fact, the denominator will always be the same.

       

      The above formula does not work.

       

      Please, correct