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