1 Reply Latest reply on Jul 27, 2016 6:58 AM by Tom W

    How to get the difference between two values in same measure.

    Koti D

      Hi All,

      Please find twbx attachment.

      Please find the below image

      dummy.PNG

      in the above image upper one is source data, below colored one is my req o/p. how to achive this?

      here i don't want pivot the scenario field, why because in my real db i have more than 100 scenarios, here i will give the prod scenario and scenario fields as filter to the user,based on user selections the scenarios gets changed.

      how to achive this?help me on this.

       

       

      thanks,

      kd.

        • 1. Re: How to get the difference between two values in same measure.
          Tom W

          I've provided two methods as attached;

          Sheet 1 involves creating a calculated field for each 'Scenario'. The downside is you need one calculated field per scenario. The upside is, you can control the placement of the metrics/columns better.

          Sheet 2 is more dynamic and uses a table calculation to assess the difference from the scenario to the previous scenario. The upside is you create it once and you're done. The downside is, there's less control over where / how you show this difference, how you label it etc.