Hello All,
Is it possible to generate active pivot output via alteryx workflow .
What i mean is the when i click on the output pivot data , it should give me detail line item level information based on which pivot was made.
Thanks.
Hi @praneshsapmm,
I don't think Alteryx have capabilities like this. I searched through the community, and fortunate for you, I have found a workaround:
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Creating-pivot-table-with-filters-like-Excel/m-p/559734/highlight/true#M121928
Basically, you would need to overwrite data in a different sheet, and the pivot table would need to be refreshed manually.
As @Emil_Kos mentioned - there's no pivot-table output available in Alteryx, but the way people do this is they set up the pivot-table in Excel pointing to a hidden sheet, and then they overwrite the data in that hidden sheet.
There are a few other options:
- You could build an analytical app that has some basic options on what data to filter / pivot by - and that produces a static pivot
- You can output this to a .tde and give people the option to do a pivot in Tableau
- you could pump this out to a SQL server and put an OLAP cube on it (or the same with Essbase) - that way you're generating an OLAP cube that can be accessed from many locations. This will take some serious engineering, but if you're dealing with pivots of a lot of data (e.g. a General Ledger for a big company) then this is the way you'd have to go eventually.
Hi @Emil_Kos ,
I tried to do this . Alteryx is updating the data sheet . But when i open the pivot sheet of this data , it opens but crashes immediately .
I idea why is this happening. Check box to refresh data while opening is already available .
