how to create pivot table with totals and filter

[Kate13122]

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

[Qiu]

@Kate13122 
Table tool can make pivot table but I am not sure about the active filter there.

Hope someone knows how.

[Nezrin]

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.

[Kate13122]

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