In my workflow am generating the excel output file. The requirement is "Grouping the rows and Ungrouping the rows" option required in the excel output file through the Alteryx workflow. Is there any method is available to generate the excel Output with grouping and ungrouping option ?.
@Hobukumar
I dont think Alteryx has the function as your requirement, which is the Excel function.
Maybe it is possible to run a VBA bat for your requirement after outputting the Excel.
Simple answer - no - this is not something that is easy to do using native functionality.
Some options:
All of these are pretty heavy-weight solutions and will require an investment of your time to make this slick.
By far the better solution would be to use Tableau for data viz - that way you can control rollups and filters really easily.