Skip to main content
Newcomer
Aug 10, 2023 10:50 AM UTC
Solved

How to create filter according to single row in cube view?

I have tried with the suppressions to make the cells that have 0 disappear but it has not been effective. In the first cell I would show how the data is arranged, and in the second image how I would like it to be

 

SofiaCuadra_2-1691663181944.png

SofiaCuadra_3-1691663209959.png

 

 

HenningAnswer
Employee - Advisor
Aug 10, 2023 11:32 AM UTC

Hi, try using the "Use to Determine Row Suppression" setting:

Henning_0-1691667081946.png

The columns BEFORE and AFTER should be False, and the one you want to use the suppression setting on (i.e. COMPARISON) should be True.

 

2 replies

HenningEmployee - AdvisorAnswer
Employee - Advisor
Aug 10, 2023 11:32 AM UTC

Hi, try using the "Use to Determine Row Suppression" setting:

Henning_0-1691667081946.png

The columns BEFORE and AFTER should be False, and the one you want to use the suppression setting on (i.e. COMPARISON) should be True.

 

Newcomer
Aug 10, 2023 11:49 AM UTC

¡Thank you very much!