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.
Quote from: learner185 on 12 Oct 2015 07:08:39 AM
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.
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.