Thank you for responding to my problem. I tried the same. (probably using lookup()). However, I need to do it without table calculation. As using Table calculation does not let you make stack graph/ or in any other graphs.
Can you think of the way without using Table Calculation?
Guys anyway to do it without using Table calculation? If no, is there anyway/ trick to convert Table calculation into Non- Table calculation ?
My end purpose is to create the stack bar graph which the table calculation won't let me.
Thanks and will appreciate any inputs.