Adding 2 Cross Tab Summarized Fields

[msi30502]

Hi All,

I have two summarized fields I need to add in a Cross Tab:

Median @Cases Sold + PopStdDev @Cases Sold

How can I create a third Column in the same Cross tab that adds these two up?

Thanks in advance

 

[CoSpringsGuy]

What version of CR are you using?

_____________________________________
Crystal Reports 2011 and XI
Intersystems Cache 2012 ODBC connection

 

[msi30502]

2008

 

[CoSpringsGuy]

Explain a little about your rows, columns and summarized fields in your crosstab...

_____________________________________
Crystal Reports 2011 and XI
Intersystems Cache 2012 ODBC connection

 

[msi30502]

Here's the Link Below. You can click the Zoom button to see details. Hope this is enough. If not, let me know.



CR8 Cross Tab Details Link

 

[CoSpringsGuy]

are you interested in trying something a little different?

if so go to this link

Link


_____________________________________
Crystal Reports 2011 and XI
Intersystems Cache 2012 ODBC connection

 

[CoSpringsGuy]

its just a link to my desktop to show you how ..... I guess I can try to explain it .. Its just a little complicated

_____________________________________
Crystal Reports 2011 and XI
Intersystems Cache 2012 ODBC connection

 

[CoSpringsGuy]

Using the sample you sent me ...
right click on the value 1.0 under Mode
select Embedded Summary then Insert Embedded Summary
You will see a new column appear with the value "Edit this formula" in each
Right click that new field and select Embedded Summary again then select edit calculation formula
Delete what is in there and enter the following formula

GridValueAt (CurrentRowIndex,CurrentColumnIndex ,2 )
+
GridValueAt (CurrentRowIndex,CurrentColumnIndex ,23 )

Save and close

Double click on the new column label @Embedded Sum and rename



_____________________________________
Crystal Reports 2011 and XI
Intersystems Cache 2012 ODBC connection

 

[CoSpringsGuy]

whups .. revised code

GridValueAt (CurrentRowIndex,CurrentColumnIndex ,2 )
+
GridValueAt (CurrentRowIndex,CurrentColumnIndex ,3 )

_____________________________________
Crystal Reports 2011 and XI
Intersystems Cache 2012 ODBC connection