topic Hide row pivot table in App Development

Hide row pivot table

Alisher — Wed, 08 Sep 2021 10:58:32 GMT

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 — Wed, 08 Sep 2021 12:43:48 GMT

try to

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

Alisher — Thu, 09 Sep 2021 06:06:49 GMT

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 — Tue, 14 Sep 2021 09:27:21 GMT

Can you send your .qvf with dummy data

AshutoshBhumkar — Tue, 14 Sep 2021 09:48:00 GMT

Hi,

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

Alisher — Thu, 18 Nov 2021 10:14:54 GMT

Alisher — Thu, 18 Nov 2021 10:16:25 GMT

Hello,

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