Calculated Value Filter in Widget Error | Help and How-To

HQ_Dev_Prod · 2025-10-14T17:38:53.141000Z

I'm trying to use CASE WHEN function in a calculated value to generate a filter for the Pivot Table Widget. This works in a bar chart, but I get an error when I try to use the same calculation and setup in a pivot table. Here are the details. The goal is to filter the table when cumulative % of total spend is less than or equal to 10%. Here I was able to tag all rows that are below 10% with the value 1. Then I use that to generate a filter "exclude all 0".

MoreDiscussions

Calculated Value Filter in Widget Error | Help and How-To | Sisense Community