Cross Tab

[cristianivanoff]

Hello All!

I have a table with these fields: {Period},{Paym},{Prodcode}

My cross tab:

Period1|Period2|Period3 etc
Prodcode1
Prodcode2
..
..
In the summarized fields I have the sum of {Paym}.

In period3 I want to show the result of [period3+period(3-1)+period(3-2)]/3. The same goes for period2 and all other periods.

Any suggestions how to solve this?

 

[nighthawk1969]

I want to assist with this question, but I'm not sure what you're trying to achieve. Can you reply back with sample data of what you have now and a mock up of the results you're trying to achieve with the sample data.

 

[lbass]

If you are trying to show cumulative averages across periods, then I think you're better off creating a manual crosstab. Insert a group on {table.prodcode} and then create a separate formula per period like this:

//{@period1}:
if {table.period} = 1 then {table.amt}

//{@period2}:
if {table.period} = 2 then {table.amt} //etc.

Place these in the detail section and right click and insert summaries on them at the prodcode group level. Then suppress the group header and details section.

For the averages, create formulas like this:

(
sum({@period1},{table.prodcode}) +
sum({@period2},{table.prodcode}) +
sum({@period3},{table.prodcode})
)/3

-LB

 

[cristianivanoff]

Thank you. I did a similar solution to your suggestion. It works fine.

//cristian