Difference in cross tab

[Former Member]

Hi All,

I was trying to calculate difference of two values in cross tab and it doesn't give me the expected result. Can someone provide on how to fix this.

Below is the example on how the report looks like -

= [Date]

=[Region] =[Measure ]

I"m running the report for 2 time periods say e.g. 12/30/2016 and 06/30/2016

I get the data as mentioned in the above structure format.

06/30/2016 12/30/2016

A. 12345. 67890

B. 13457. 78932

C. 78392. 473822

Now, I would like to add a new coulmn to this cross table and would like to show the difference in it.

I was able to get the required o/p if I use the below formula -

=(Sum([measure])where([Date]='12/230/2016') - sum([measure]) where ([Date]='06/30/2016")

I also tried by passing the user response value and also tweaked the above formula to pass the max date and min date instead of hard coding the dates but I don't get the expected results.

I would like to have inputs on how to achieve this. Thanks in advance.