Reload data into excel with user's filtering input

Hi All,

I am using BPC 10 and I have manage to load the data into an excel sheet.

What I am trying to do now is allow user to filter the result based on user's input e.g. user can select a category then input the value and it will filter accordingly.

What I have in mind is reload the data based on user input through VBA API I have tried all the API available in the BPC guide but didn't manage to find any suitable API.

Anyone have any idea how I should approach this filtering ??

Regards,