5 Replies Latest reply on Jul 26, 2018 12:33 PM by Deepak Rai

    Previous period values next to current values as a new column

    rao marapatla

      Hi All,

       

      I have a simple requirement ,wanted to bring previous values as second column and display next to the current values. attached screenshot and workbook.

       

      please have a look.

       

      thanks

       

      Deepak Rai thank for your prompt response

       

      I have recreated based on your suggestion its not satisfying all the combination of requirement could you please relook into it and help me attached new work book.

       

      Requirement :

       

      1.I have a Period and Region and corresponding makets,I have a filters on period and regin as well. if I pick 6+6

       

      report shuld return 2 regions and respective markets  and value1 and in new column I wanted to display value1 as a 5+7 data .

       

      thanks in advance - attached new workbook with actual data