Skip to Content
0
Former Member
Jan 07, 2008 at 06:52 AM

Counting Characterstics based by differinating the values

21 Views

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