double entry table and set modifiers

[Anonymous]

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

[sunny_talwar]

I think you need to look at this thread

Canonical Date