Skip to Content
0
Former Member
Nov 03, 2012 at 06:57 PM

Problem with Cross Tab Report

25 Views

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 Moderate

Year 2011

Header 1 Header 2 B Low D Low E Moderate F High

Year 2012

Header 1 Header 2 A High D High F Moderate G Low

Cross 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 Low

But 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 Low

Thanks a lot in advance