Matrix Group Report

sunil.style2005 · #1 (**permalink**) 02-01-12, 23:49

Hi All,

Im Sunil, Im created a Matrix Group Report in Oracle. But I have one issue in that report.

Code:

Year	80
	Job	Clerk
Dept No
10		800
20		500

Year	81
	Job	Analyst      Clerk	Manager
Dept No
10		200		300	500
20		400		200	500

Above mention report have year wise job in different departments. But that report in Year 80 Only one column Clerk & that Year 81 3 columns. I want Year 80 3 columns its column blank or not.

Thanks

tonkuma · #2 (**permalink**) 02-02-12, 00:24

Please use [CODE] tag to display sample data.
Because, it was left justified and correspondance of columns and values are not so clear.

Another question is why "Dept no" was second line in Year 81 and third line in Year 80?

Internet Services

Web Development

Digital Marketing

Consumer Tech