I have the following data
employee calday measure1 measure2 measure3
1 01/01/2010 10 20
1 02/01/2010 12 10
1 03/01/2010 2 9
1 15
I need to show the crosstab report
calday 01/01/2010 02/01/2010
employee measure3 measure1 measure2 measure1 measure2
1 15 10 20 12 10
but cross tab report adds two more columns for measure 1 & 2 with null calday value.
when i apply the report filter calday is not null then it filters out the measure3 & shows blank there.
measure3 dosent show the value even i do NoFilter(measure3;All)
please suggest how can i achieve this.
swapnildharia (BOB member since 2010-06-14)