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 ??