1 Reply Latest reply: Feb 21, 2017 2:59 PM by Rupam Das RSS

    Semi Additive Measure in Bar Chart

    Hannah Lines

      Hello,

      I am trying to create a bar chart using a semi-additive measure and cannot seem to get the correct expression syntax using the FirstSortedValue expression. 

       

      Please see screen shot below. I would like the bar chart to show the number of Comms for the most recent Service Period (blue boxes), and not the total (red boxes). This is like a bank balance where it cannot be summed over time. Would someone be able to suggest how I can achieve this?

      screen shot.jpg