Crosstab Report Issue

[ipcm]

jan feb Mar Apr May Total
Name 1 3 2 5 7 4 21
Name 2 5 1 5 3 3 17
Name 3 2 8 10 12 1 33
Name 4 17 1 1 5 3 27

Question 1. Is there a way to add additional Calculation beside the total on the right of the Total Column. eg, the above data shows units but not revenue, could the calc on the right of total show rev\units? I have revenue data seperate.

Question 2. Could a similar spread as above in percentages be added next to the existing crosstab report, in other words it probably means two crosstab reports side by side?

 

[lbass]

Your version of CR?

-LB

 

[ipcm]

I have version 10

 

[ipcm]

jan feb Mar Apr May Total
Name 1 3 2 5 7 4 21
Name 2 5 1 5 3 3 17
Name 3 2 8 10 12 1 33
Name 4 17 1 1 5 3 27

Question 1. Is there a way to add additional Calculation beside the total on the right of the Total Column. eg, the above data shows units but not revenue, could the calc on the right of total show rev\units? I have revenue data seperate.

Question 2. Could a similar spread as above in percentages be added next to the existing crosstab report, in other words it probably means two crosstab reports side by side?
I have version 10

 

[ipcm]

Hi, can someone help me with the following questions.

jan feb Mar Apr May Total
Name 1 3 2 5 7 4 21
Name 2 5 1 5 3 3 17
Name 3 2 8 10 12 1 33
Name 4 17 1 1 5 3 27

Question 1. Is there a way to add additional Calculation beside the total on the right of the Total Column. eg, the above data shows units but not revenue, could the calc on the right of total show rev\units? I have revenue data seperate.

Question 2. Could a similar spread as above in percentages be added next to the existing crosstab report, in other words it probably means two crosstab reports side by side?
I have version 10

 

[lbass]

For question #1, I'm not sure whether cr 10 allows horizontal summaries (crosstab->customize style->summarized fields->display horizontally, but if it does, set up your crosstab that way. Then create a formula:

whilereadingrecords;
0

Add sum of revenue as your first summary, count of units as your second, and sum of the above formula {@0} as your third. This will act as a place holder. If you only want the rev/units in the row totals, then in preview mode, select the row total for revenue and the corresponding grand total for revenue->format field->common->suppress->x+2 and enter:

whileprintingrecords;
currencyvar amt := currentfieldvalue;
false

Then go to the same suppression area for the count summary (and its grand total) and enter:

whileprintingrecords;
numbervar cnt := currentfieldvalue;
false

Then select the {@0} and its grand total->format field->common->DISPLAY STRING->x+2 and enter:

whileprintingrecords;
currencyvar amt;
numbervar cnt;
totext(amt/cnt,2)

Then suppress the column label, inner cell, and column total for the {@0} summary, and then select an inner cell for the {@0} summary and drag the border to minimize its width.

Your 2nd question is unclear. Percentage of the row total? the column total? the grand total? You should be able to choose percentage when you set up your summaries--as long as you are basing it either on row or column totals, and not the grand total.

-LB