Crosstab for total missing count

[ridhirao22]

Using Crystal Report 2008 and SAP-Bex query as source

I am trying to mimic exit analyzer report which has to be refreshed manually daily so I can auto mate it in CE CMC.

I have store, Store name, Data for last 2 weeks and each day date as columns and store & store name as rows.. I was able to do this; I need help with 2 other things and appreciate your suggestion.

1. I need to do a total count of missing values for each day an show them on top.
2. Can I show the abbreviated day name above the date.

Below is the sample I would like to see the report.
PRIOR WEEK CURRENT WEEK
SUN MON TUE WED THURS FRI SAT SUN MON TUE WED THURS
5 5 1 0 0 0 0 1 0 2 1 2
9/1/2013 9/2/2013 9/3/2013 9/4/2013 9/5/2013 9/6/2013 9/7/2013 9/8/2013 9/9/2013 9/10/2013 9/11/2013 9/12/2013
354,161 385,970 133,028 132,405 153,277 193,812 318,984 216,021 129,597 128,849 134,783 137,828
111 aaaaa 2,216 2,188 753 529 811 780 1,126 1,034 510 564 381 455
222 bbbbb 1,250 1,157 344 251 312 354 638 482 200 167 262 179
333 ccccc 1,802 2,116 251 263 275 545 1,123 901 292 249 275 294
444 ddddd 1,400 1,828 294 290 289 434 1,073 606 234 247 292 285


TIA,
RR

 

[ridhirao22]

Please let me know if this is even doable? Thanks!