ridhirao22
Programmer
Using CR2008 and SAP BEX Query as source for data.
I have a cross tab which displays as below:
10/5/2013 10/6/2013 10/7/2013 10/8/2013 10/9/2013 10/10/2013
1111 10 20 25 22 35 0
2222 35 20 0 10 5 8
3333 0 10 5 15 40 0
4444 0 5 30 15 0 16
5555 0 8 10 0 0 0
But I would need to see the summary/count of zero in the cross tab displayed on top of the each date column:
3 0 1 1 2 3
10/5/2013 10/6/2013 10/7/2013 10/8/2013 10/9/2013 10/10/2013
1111 10 20 25 22 35 0
2222 35 20 0 10 5 8
3333 0 10 5 15 40 0
4444 0 5 30 15 0 16
5555 0 8 10 0 0 0
Could anyone please suggest how I could achieve to do this?
TIA,
RR
I have a cross tab which displays as below:
10/5/2013 10/6/2013 10/7/2013 10/8/2013 10/9/2013 10/10/2013
1111 10 20 25 22 35 0
2222 35 20 0 10 5 8
3333 0 10 5 15 40 0
4444 0 5 30 15 0 16
5555 0 8 10 0 0 0
But I would need to see the summary/count of zero in the cross tab displayed on top of the each date column:
3 0 1 1 2 3
10/5/2013 10/6/2013 10/7/2013 10/8/2013 10/9/2013 10/10/2013
1111 10 20 25 22 35 0
2222 35 20 0 10 5 8
3333 0 10 5 15 40 0
4444 0 5 30 15 0 16
5555 0 8 10 0 0 0
Could anyone please suggest how I could achieve to do this?
TIA,
RR