how to create pivot table with totals and filter

Question

Dear great community!

I have an issue with creating a pivot table. I would need to have a pivot table as in Excel. It means with totals and with active -interactive filters.

Please find attached an example of what I mean.

I could not find anything on the internet.

Could you please help me with how to reach this?

Thank you very much in advance.

Katarina

Capture.JPG

sparkle · Answer

Hi @Nezrin,

I also have same scenario. Would like to create pivot table with interactive Filters. can you please help how to do it using Alteryx designer. 
Thanks in advance.

Kate13122 · Answer

Hi @Nezrin  could you please advise how to reach this?

what should I use to get the filter as is in the capture?

thank you

Nezrin · Answer

You can build an analytic app if you want to make the filter interactive. You can find the tools form the "Interface" tool category. Based on user selection, you can use Summarise tool to calculate the pivot values.