10 Replies Latest reply on Jul 16, 2018 4:15 AM by Vijay Srikanth GVL

    How to do row wise comparison from a single data source

    Vijay Srikanth GVL

      Hello experts,


      I have one tde file which has the extract of current quarter information on a weekly basis something like below


      In the database i have dimensions as Number, Stage, Close quarter etc. So the challenge here is to show the sum($ Value) for change in Stage for example on 2nd July Numbers 4 & 5 are in SS-04 but on 9th July they have changed their stage to SS-05 similarly Number 2 & 6 have moved from 2018-Q3 to 2018-Q4.


      I have attached the excel file for your reference, would be great if anyone can guide me to achieve the results.


      Thank you in advance.