Set Analysis for two dates selected

[#1]

Hi All,

I am trying to calculate the difference between order counts and order values for two dates selected.

Please find attached the data and output files.

Thanks in advance

[#2]

Please help I have been struck for a while

[Anonymous]

If I understand your requirements correctly, and assuming that both dates are from the same field [Order Date], this will help (maybe you need some variations of this):

sum({<[Order Date]={"$(=date(max([Order Date])))"}>} [Order Value]) - sum({<[Order Date]={"$(=date(min([Order Date])))"}>} [Order Value])

Regards,

Michael