Skip to Content
0
Oct 29, 2015 at 09:12 PM

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

17 Views

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