Skip to Content
0
Aug 21, 2012 at 09:59 AM

Cross tab issue

22 Views

Hi experts,

I created a crosstab report with Material , , division , fiscal year.Quantity,and revenue.

I Created a report filter for fiscal year for the year 2008,2009,2010,2011,2012.

For division i created the section.

the report look like below.

*********************************************

D26(division)

fiscal year 2009 qty 2009 reven

Material

A 1 10

B 2 50

C 3 60

*******************************************

because there is no values for the 2008,2010,2011,2012.

But i need to show the year which also has blank means there is no sales on those years.

for this i tried with show/hide properties of the table but didn't work.

So i created another query with adding just Fiscal year object and with query filter for the years 2008-2012.

Now i drag the Fiscal year from query2. then i got the following report.

*********************************************

D26(division)

fiscal year 2009 qty ! 2009 reven ! 2008 qty ! 2008 reven ! 2010 qty ! 2010 reven !2011 qty ! 2011 reven ! 2012 qty ! 2012 reven

Material

A 1 10

B 2 50

C 3 60

*******************************************

Here the problem is 2008 should come first.which fiscal year has values its showing first. I tried the sort option but no use.

i'm expecting

*********************************************

D26(division)

fiscal year 2008 qty ! 2008 reven ! 2009 qty ! 2009 reven ! 2010 qty ! 2010 reven !2011 qty ! 2011 reven ! 2012 qty ! 2012 reven

Material

A 1 10

B 2 50

C 3 6

Regards,

Sree