Not working "show all" at row settings

Hi there,

I'm wondering if we can't use data view settings "detail by" and row settings "show all" at the same time.
If I set "detail by", it shows all data(zero) although setting "show all" .
I want to hide row having zero. Could anyone help me solve this?

Kind regards,
Marie

------------------------------
Marie Kawakami
Developer
MRI VALUE CONSULTING AND SOLUTIONS CO., LTD.
Japan
------------------------------

Find more posts tagged with

Accepted answers

All comments

Samir Jones

Hi,

If you haven't solved it, here's a workaround to hide empty rows.

1. Create an algorithm block (block 'b' in screenshot) that checks if the source cube (block 'a' in screenshot) has values. Algorithm can look like this "if(a<>0,1,0)". This should give you '1' in the block's column for all the rows that has values.
2. Go to Filter and set filtering on that block with min '1' and max '1'.
3. If it seems to work, you can hide the algorithm block.

------------------------------
Samir Jones
Developer
Attollo AB
Sweden
------------------------------
-------------------------------------------

Etienne CAUSSE

As "Detail by" works on column, you might need to remove "show all" from the column properties to hide zeroes and not from rows properties.-------------------------------------------