Need to create Pivot table with active filters.

[MamtaL]

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,

[binuacs]

@MamtaL I don't think you can create the exact same excel pivot functionality using Alteryx, may be you should go with python

[MamtaL]

@binuacs
Thanks for your response. But I am not aware of Python and trying to get solution using Alteryx. 

[Qiu]

@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.

[nagakavyasri]

@MamtaL Try the attached solution:

[MamtaL]

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.

[Qiu]

@MamtaL 

I dont believe we can immediately create active filter in Excel by Alteryx Output. 🤔