Converting Data in Crosstab format

[SuperTime]

Application: VO_Service
Summary: 65627 19332 29.46%

Thu, Dec 9, 04
12am-8am 233 60 25.75
8am-4pm 978 167 17.08
4pm-12am 1126 398 35.35
Daily 12/9/2004 2337 625 26.74

Fri, Dec 10, 04

12am-8am 181 51 28.18
8am-4pm 1114 357 32.05
4pm-12am 968 419 43.29
Daily 12/10/2004 2263 827 36.54

Sat, Dec 11, 04

12am-8am 163 71 43.56
8am-4pm 804 315 39.18
4pm-12am 623 248 39.81
Daily 12/11/2004 1590 634 39.87

Sun, Dec 12, 04

12am-8am 107 33 30.84
8am-4pm 706 88 12.46
4pm-12am 716 245 34.22
Daily 12/12/2004 1529 366 23.94

Mon, Dec 13, 04

12am-8am 141 56 39.72
8am-4pm 1362 415 30.47
4pm-12am 1615 711 44.02
Daily 12/13/2004 3118 1182 37.91

Above is the current format of my report.

I want to convert it in the crosstab format

I want it to be

Thu, Fri Sat Sun...
12am-8am
offered 233
abandond 60
% abd 25.75


PLease any suggesttion are highly appretiated

 

[synapsevampire]

The required output suggests a manual cross-tab in which you would have to build formulas for each data element, inclusive of the dates.

An example of the dates might be currentdate-4 to get last Thursdays date.

Then to accumulate those you can use a Running Total or a manual formula to accumulate the quantities using a similar filtering:

Running Total:

Select the field to sum
In the Evaluate Use a Formula place something like:

{table.date}=currentdate-4
and
hour({table.date}) in 0 to 8

Keep in mind that hour works on 24 hour time for the formulas after noon.

You'll have to create formulas for each data point of interest.

-k