It would be great if you could select multiple Data Fields in a single Crosstab
For example. I would like to SUM (Methodology) Pet Food Sales (Data Field 1) & Baby Food Sales (Data Field 2) By Store (Grouping Field) By Day of Week (Header field).
I think this answer may only be the solution because you simplified your question to ask it, but the above example is able to be acheived by use of a formula tool before the cross tab. A new field "Data" = "Pet Food Sales" + "Baby Food Sales", then the new field "Data" would be used as the Data Field in the Cross Tab. Creating the extra field doesn't matter because you are about to Cross Tab it and so get rid of any fields not selected in the Cross Tab.
Oh, sorry, I misunderstood. That is a situation that can cause confusion. I understand why you would like that. Until it is reviewed for implementation, I've listed below some ways that may work for you.
Currently the options are:
Transpose first to get them into the same column to then crosstab,
Or to run multiple crosstabs in parallel. One for each column and then join them back together using the Join Tool. So essentially, you will have your Input going to 2 crosstabs and then those both going to a Join tool as in the below screenshot.
Remember to:
Untick the duplicate fields in the join tool though.
Have the same Grouping Fields selected in each CrossTab
As this was posted a couple of years ago, wanted to circle back and see if there was any better solution than the one above. It seems to work, but wasn't sure if there was a more robust answer available with recent updates.
I found that using Option 1 above - transpose first, get all the values into one column very helpful. Otherwise, with Option 2, I would have to create 8 crosstabs first.
Thank you for your idea! Our product team has reviewed this idea and cannot place it on the road map at this time. However they would still like to keep it in mind for future road map decisions. We'll update the status of this idea once we are able to term where or if we can place it on the road map.