Hi, i am having a problem with cross tab report which will show ratings of products based on year. I am having similar data like below
Year 2010
Product Risk A High B Low C High D ModerateYear 2011
Header 1 Header 2 B Low D Low E Moderate F HighYear 2012
Header 1 Header 2 A High D High F Moderate G LowCross Tab(Here i am getting problem, Getting more number of rows, i know its because each product will have different ID, and also its not an duplicate.)
YEAR 2010 YEAR 2011 yEAR 2012 A High A High B Low B Low C High D Moderate D Low D High E Moderate F High F Moderate G LowBut Actual Result i need like(Can any one suggest any solution like, by using alerter or any other way to solve the issue)
yEAR 2010 Year 2011 Year 2012 A High High B Low Low C High D Moderate Low High E Moderate F High Moderate G LowThanks a lot in advance