Skip to Content
0
Former Member
Dec 15, 2006 at 07:20 AM

How to add a calc on a crosstab cell outside of the crosstab

20 Views

cr4e newbie here, plz forgive my limited knowledge.

I have a crosstab that is totaling four numeric buckets nicely, but some users would like to see calculations (percentages) based on two of those buckets -- outside the crosstab. I'm not saying this is a good idea, I'm just describing the situation...

In the past, I have referred to cells outside of a crosstab in a pivot table [MS Excel], and I'm hoping to somehow get away with this in cr4e.

I did some digging and I can see cells identified as crosstab total cells in the Outline tab of the cr4e report designer.

The report outline looks a bit like this:

Crosstab1

+Rows

+Cells

-Summaries

-Crosstab1(sum0)

-Crosstab1(sum1)

-Crosstab1(sum2)

-Crosstab1(sum3)

+Cell: Dept by BSNSS_DT - Sum({myTable.this})

+Cell: Dept by Total Column - Sum({myTable.that})

+Cell: Total Row by Total Column - Sum({myTable.theOther})

I cannot drag any of the cells into the report layout nor have I found a way to refer to them in a function.

Any ideas?