Hi,
I have a requirement where in I have the charactestics
Target Industry , , Acquiror industry
Sample data:
TInd_____ AInd_____
Ban_____ Ban_____
Ban_____ RET_____
Ins_____ BAN______
INS_____ INS_____
RET_____RET______
RET_____RET_____
Here for example take the 2nd record
When we see in the 2nd &3rd record data the Target industry data & Acquiror industry data are not matching
If the values of Target industry & Acquiror industry are not matching then it is called a vertical
If theta re matching then it is called as Horizontal.Now in my report I need to Count how many of them are Vertical and howmany of them are horizontal.How can I count the characterstic based by differanting the values
Report o/p should be like this
TInd____ No. of Verticals____No. of Horizontal
Ban____1_________________1
INS____1_________________1
RET____0_________________2
How can this be done
Regards.
Maya