4 Replies Latest reply: Oct 4, 2017 12:25 PM by Sunny Talwar RSS

    Expression independent from dimension


      I want to form a chart/table where I can view my cost values. And in addition I want to add a column where I can view cost/revenue. SO since my Cost is filtered in my measure (measureID, by selection, I need to make revenue independent from that filter, while it still obeys date,etc.


      easureID, date, value

      cost1, 1/1/2017, 10

      cost2, 1/1/2017, 33

      cost3, 1/1/2017, 23

      revenenue, 1/1/2017, 100




      I've tried the following. But it seems to be stilled overruled by my measureID selection.


      sum(value) / Sum({<[measureID]={'revenue'}>} value)