Pivot Table: Hide Row based on count
I have a pivot table listing out test taken. Currently it list all test taken but I only want to show the row if all three test have been taken. So if test A and test C have been completed but not te...
Forum Discussion
Hi zach_myt ,
One solution to address this issue is to create a value field within the pivot table using a below formula. Then, apply a filter to this value field, such as filtering for values equal to 3. Additionally, you can use a widget script to hide the column.
(count([Test]), all([Test]))
Here is an example:
1. Let say in the widget below, you want to display records where all four conditions (New, Refurbished, Unspecified, and Used) are listed.
2. Create a Value field in the pivot table with the provided formula, which calculates the number of conditions for each record.
3. Apply a filter to the value field, specifying to display values equal to 4.
Once the filter is applied, the pivot will display only the records that have 4 conditions as below
4. Utilize a widget script to hide the pivot column that displays the count. Refer to this community post for guidance on hiding a column in a pivot table.
Feel free to reach out if you have further questions, we're always happy to help 🙂
[email protected]
Paldi Solutions, Number #1 Sisense Plugins Developer
