Help me in Filtering a Pivot Table

Help Studio
, ,
1

I have used these activities to create a pivot table.

image
image461×737 24.3 KB

I want to filter the pivot table like this :

image
image1889×828 57 KB

By clicking the arrow in row cost element
image
image691×221 102 KB

I have tried to Filter the Pivot table by using the Filter Pivot Table activity:
image

However, I got this error:

image
image1559×137 26.7 KB

The full error message is this:

System.ArgumentException: Column does not exist.   at UiPath.Excel.Activities.QuickHandle.RangeRefExtensions.GetRelativeColumnIndexFromColumnName(IReadWriteRangeRef range, String columnName, Boolean extendUsedRange)
   at UiPath.Excel.Activities.Business.FilterX.ExecuteFilterAsync(AsyncCodeActivityContext context, IReadWriteRangeRef rangeValue, String columnName, IExtendedWorkbook workBook, IRangeValueFilterProcessor filterProcessor, CancellationToken cancellationToken)
   at UiPath.Excel.Activities.Business.FilterX.ExecuteAsync(AsyncCodeActivityContext context, CancellationToken cancellationToken)
   at UiPath.Shared.Activities.AsyncTaskCodeActivityImplementation.EndExecute(AsyncCodeActivityContext context, IAsyncResult result)
   at UiPath.Shared.Activities.AsyncTaskCodeActivity.EndExecute(AsyncCodeActivityContext context, IAsyncResult result)
   at System.Activities.AsyncCodeActivity.System.Activities.IAsyncCodeActivity.FinishExecution(AsyncCodeActivityContext context, IAsyncResult result)
   at System.Activities.AsyncCodeActivity.CompleteAsyncCodeActivityData.CompleteAsyncCodeActivityWorkItem.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)
--- End of stack trace from previous location ---
   at UiPath.Executor.BaseRunner.EndExecute(IAsyncResult result)
   at UiPath.Executor.InProcessRunner.EndExecute(IAsyncResult result)
   at UiPath.Core.Activities.ExecutorInvokeActivity.EndExecute(AsyncCodeActivityContext context, IAsyncResult result)
   at System.Activities.AsyncCodeActivity.System.Activities.IAsyncCodeActivity.FinishExecution(AsyncCodeActivityContext context, IAsyncResult result)
   at System.Activities.AsyncCodeActivity.CompleteAsyncCodeActivityData.CompleteAsyncCodeActivityWorkItem.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)

Can someone help me on this, help me on how to Filter a Pivot table.

Thank you.

2

@RobinsonFrancis

Instead of writing the name…can you select directly on excel and check if that works

Cheers

3

Hi @RobinsonFrancis

Please check the sheet name.

Regards

4

I think I have got that right, this is the

image
image1396×520 42.4 KB

This is my filter configurations:
image