Hello,
My data looks like the following table :
| ID | New Date | Old Date | New Version | Old Version |
|---|
| 1 | 12/01/2018 | 11/01/2018 | ST1 | ST2 |
| 2 | 21/01/2018 | 21/01/2018 | ST2 | ST2 |
| 3 | 23/02/2018 | 22/03/2018 | ST2 | ST2 |
And I would like to have the following double entry table in my sheet in order to compare the new and the old data
| Version | January | January | February | Fabruary |
|---|
| New | Old | New | Old |
| ST1 | 1 | 0 | 0 | 0 |
| ST2 | 1 | 2 | 2 | 2 |
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
