Forum Discussion

y3wan's avatar
y3wan
Frequent Visitor
4 years ago
Solved

Suppression within matrix table challenges

I have created a Matrix table with Number and Percentage Conversation + Suppression.

 

 

 

 

However, I realized my audience can calculate the suppressed value by taking other numbers under the same column and divided by it's percentage value. 

Therefore I am attempting to suppress the entire column (under Percent) if there are any "<10" values.

 

Anyone may share their experience or have ideas to achieve such end result would be much appreciated.

 

Should I create some sort of group to target those values under those dynamic columns?

Need Help

3 Replies

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Community Support
    4 years ago

    Hi y3wan ,

    What do you mean "suppress the entire column", could you please explain more about your expected result?

    Best Regards,
    Community Support Team _ kalyj

  • y3wan's avatar
    y3wan
    Frequent Visitor
    4 years ago

    In the table above, the value for Shampoo in store B is suprressed as "<10"
    When I convert my value to percentage, audience can calculate the suprressed value by using other Shampoo values and divided by it's percentage value.

     

    As a result, I also need to suppress the percentage values for all other stores under shampoo.

     

    And here come's the tricky part; This is a matrix table which the values is based on a measure calculation.

     

    Anyway I was able to achieve a workaround by creating a new column in my source table that would indicate all the percentage values that would need addition suppression.

     

    Thank you