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.
Any ideas on how to summarize this way?
Solved! Go to Solution.
Unfortunately I need it like the layout on the right. Otherwise I'd just summarize it. I appreciate you looking at it so quickly.
Please see the output below
Attached the workflow.
If this solves your issue please mark the answer as correct!
Regards,
Hi @knobsdog,
See attached - It follows the same principle as the first solution then just plays around a bit with placement of the records.
Regards,
Ben
This is exactly what I was looking to do. Thank you so much. I've spent lots of hours playing around with trying to get to this...lol
I'll take a look at this one too for further info. Thank you for responding.