Need to create Pivot table with active filters.
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
Can someone help me with How to create Pivot Table with Active filters in excel using desktop designer. Attaching Input data and expected output Pivot table. Attaching excel which contains Sample data in Sheet "Input data" and Would like to get output excel with only Pivot table which is mentioned in sheet "Expected Output". upper line filters should be generated in output file which is marked in screenshot.
I read somewhere it is possible with Analytics Apps in Designer desktop. But not sure how to do it. Can some one please help me with the solution or guideline to achieve this. Thanks in advance.
Thanks,
- Labels:
- App Builder
- Data Investigation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@MamtaL I don't think you can create the exact same excel pivot functionality using Alteryx, may be you should go with python
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@binuacs
Thanks for your response. But I am not aware of Python and trying to get solution using Alteryx.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@MamtaL
Alteryx is not a Run-time application so it can do filter dynamically as you need.
We can use Analytic App as below by providing selection in List box.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
HI @Qiu and @nagakavyasri
I tried both of your solution, But still not getting what i am expecting. Please note, Exact same Output as mentioned in Sheet. and with active filter in excel, not in Alteryx.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I dont believe we can immediately create active filter in Excel by Alteryx Output. 🤔
