Manual cross-tab help

[peteriannetta]

Hi there,
I've been reading a number of posts regarding workarounds to cross-tabs not allowing summarised formulas (which in itself sucks, but that's another post). I use CR8.

What I'm trying to achieve is the following:

Interval Date Date-1 Date+1
08:00 12% 15% 20%
08:30 9% 11% 0%
etc...

A cross-tab works fabulously when each interval has one record (using the built-in summary options) but when an interval has more than one record, I have a formula which captures the data and creates the appropriate result (which cannot be achieved using a simple summary).

I've tried to get my head around how to construct a manual cross-tab but can't seem to get it. Could someone please help to explain at least how I'd get started.

Many thanks,
Pete

 

[lbass]

Have you read the FAQs on manual crosstabs? It would help to have the contents of your formulas, but basically you would group on your "row" field {table.interval}, and then create a formula for each column, as in:

//{@col1}:
if {table.date} = currentdate then {@percent}
//subsitute your column date criterion for "currentdate"

//{@col2}:
if {table.date} = currentdate-1 then {@percent}

//{@col3}:
if {table.date} = currentdate+1 then {@percent}

Then you would insert summaries on these and suppress the detail section.

This might be more complicated, depending on the contents of your formulas.

-LB

 

[peteriannetta]

Thanks LB. I have read the FAQ's and other various web references.

I'm happy to post the formulas but they are quite complicated and they refer to a number of other formulas - it could be "war and peace"!!

Thanks for your suggestions - I'll start working on it the way you have suggested and see how far I get.

Cheers,
Pete