Hide row pivot table

[Alisher]

Hello,

please help on this issue.

Created a pivot table but can't hide empty rows.

Here is the original table:

It is necessary to hide those lines where the "details" column is empty:

But if I uncheck the "Show null values" box, then the Client and Business lines disappear from Income.

Now, how can you make the blank lines not appear, but the Business and Client lines are displayed as an amount?

Thank you in advance

[NitinK7]

try to

uncheck the "Show null values" box, for "article  or details" dimension

[Alisher]

If I uncheck the "Show null values" box for details, then the Client and Business lines disappear from Income.

If I uncheck the "Show null values" box for artcile, then no changes.

[NitinK7]

Can you send your .qvf with dummy data

[AshutoshBhumkar]

Hi,

Maybe you can replace null values with space (' ') if you don't want to show '-'

[Alisher]

Hello,

The problem is not that the minuses are displayed, but that I want remove them altogether