Experts
I have done in excel pivot and get the expected result but i am struck in alteryx to get the same results
could you please help me on this if anyway to get same results
I have attached with data and excel pivot
Excel Pivot
Hello,
You have a complex pivot table. Not sure if you can got this on Alteryx, but i think the best way would be using cross tab and table tool.
I'd prefer to just update the "Data" tab with Alteryx, and keep using the pivot table of excel, which is more dynamic.
Ore use another visualization tool, like Tableau, Power BI.
Hope this helps,
Tanai.
