1 Reply Latest reply: Mar 6, 2018 4:59 AM by Sunny Talwar RSS

    double entry table and set modifiers

    Caroline Huet

      Hello,

       

      My data looks like the following table :

       

       

      IDNew DateOld DateNew VersionOld Version
      112/01/201811/01/2018ST1ST2
      221/01/201821/01/2018ST2ST2
      323/02/201822/03/2018ST2ST2

       

      And I would like to have the following double entry table in my sheet in order to compare the new and the old data

       

      VersionJanuaryJanuaryFebruaryFabruary
      NewOldNewOld
      ST11000
      ST21222

       

      The issue is that I have to select "new date" as a dimension but I need information from old date also.

       

      So I tried the following expression to have data from "old date" : =Count( {<[Old Date.autoCalendar.Month] -= [New Date.autoCalendar.Month]> } ID)

       

      But it doesn't work...

       

      Do you have an idea to solve this issue ?

      i thought about having a different table at the beginning but i need this layout to do other comparison...

       

      Best regards

       

      Caroline