Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Cross tab summary help

Status
Not open for further replies.

ridhirao22

Programmer
Aug 27, 2010
140
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top