Skip to Content

Is it possible to derive shared variables from multiple columns of a cross tab?

I have a main report with a cross tab as well as a crosstab in each subreport (2). Each cross tab is set up the same (but pulling from the same data set with much different criteria each time) with the column variable producing up to two different columns plus a summary column. Is it possible to derive a shared variable from all three columns? I don't need to produce another cross tab, I just need to show the totals.

What I'm looking for is:

Main report (Sale A)

                              Online               InStore      Total

Product 1

Product 2

Product 3

                                   5                         8              13

Subreport (Sale B)

                              Online               InStore      Total

Product 1

Product 2

Product 3

                                   40                     93           133

Subreport (Sale C)

                              Online               InStore      Total

Product 1

Product 2

Product 3

                                   15                   14              29

Totals

                              Online               InStore      Total

Sale A                         5                      8              13

Sale B                         40                     93            133

Sale C                         15                      14             29

                                  60                        115             175

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 30, 2015 at 08:11 AM

    Hi Kurt,

    It is going to be extremely difficult to do this with shared variables.

    The easier solution is to use a single crosstab.

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded