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.
Find answers, ask questions, and share expertise about Alteryx Designer.
General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!
I've been searching to no avail to find a way to use the Summarize tool by itself or in conjunction with crosstab or transpose to setup a nested summary table. I have 3 stores with different category items for different dates. I want to group by the Store name and then dates under it with a count of the items in columns. I can't attach my workflow due to proprietary data but I did a screen shot of some generic data I've mocked up. On the left is how my data comes from Crosstab tool and the right hand pic shows what I'd like it to look like.
Having two rows of headers isn't the most efficient from a data standpoint. Would it be okay if the values in the first column are broken out into two? If so, you can achieve this with the cross-tab. I added a data cleansing to fill in the nulls.