Skip to Content
0
Feb 12, 2020 at 06:10 PM

Is this Possible As CrossTab?

45 Views Last edit Feb 12, 2020 at 06:44 PM 2 rev

I need to place values (not aggregates) at the intersection of Room>Table>Gender and Chicken|Fish|Vegan.

I then want to total the columns (Chicken|Fish|Vegan) in two ways a total and a total when the person is a first timer.

I'll carry an indicator for first timer and a calculated field to indicate the name or #name.

Essentially, I am asking if I can use the CrossTab Expert to do this or do I need to produce a result set that is set up like this and then add my own group totals? If I do the later, the issue will be that the number of columns can vary (e.g. Prime Rib can be added)

Thoughts?

Thank you,

N