This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
It would be great if you could select multiple Data Fields in a single CrosstabFor 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).
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'm also wondering if there is a better method to address this situation.
As am I - any 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.
Thanks @PaulaH - that saved me some head-banging on the desk. Perfect 🙂
I can't believe multiple value columns are not a standard feature of Cross Tab?! I must learn how to write macros to fix this once and for all!
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.
This is a pity! Hardly seems like an obscure requirement - I'd have expected this as a basic feature and something which would be frequently used?
But, thanks for the update nonetheless
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.