Forum Discussion

zach_myt's avatar
zach_myt
Data Pipeline
01-03-2024

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 test B then that persons data would be removed. If ABC have been taken then continue to display as normal. I attached a picture for reference, I only want do show the highlighted row.

Any ideas?

2 Replies

Replies have been turned off for this 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

     

     

     

     

     

  • Hello zach_myt.

    Can you take a look at the solution from Benji_PaldiTeam and let us know if it solves your problem? If it does, please accept it as the solution so that other people with the same question can find it easier. 

    Thank you.