Difference between crosstab rows

[learner185]

Hi All,

I have crosstab report with country as column and year as row. The measure is sales. Need to find difference between the crosstab rows. I have only 2 year values: 2014, 2015.
Basically, want 3rd row to be difference between 2nd row- 1st row of crosstab.

          UK   India
2014   10     20
2015   15     30
diff      5       10

Its urgent.

Pls help

Thanks.

[MFGF]

Hi All,

I have crosstab report with country as column and year as row. The measure is sales. Need to find difference between the crosstab rows. I have only 2 year values: 2014, 2015.
Basically, want 3rd row to be difference between 2nd row- 1st row of crosstab.

          UK   India
2014   10     20
2015   15     30
diff      5       10

Its urgent.

Pls help

Thanks.

Are you using a dimensional package or a relational package?

MF.

[MFGF]

Two days have gone by and you haven't responded to this. You posted "It's urgent" (even though this contravenes the forum etiquette guidelines) so I responded quickly, asking for more information so we could try to help. Your lack of response seems to indicate that there is no urgency in this matter at all?

Please read the forum etiquette post, paying particular attention to point 2.

http://www.cognoise.com/index.php/topic,24030.0.html

MF.