Skip to Content
0
Jun 10, 2020 at 06:17 PM

Delete/Hide rows with 0 values in SAP Analytics Cloud

934 Views

Hello,

I am writing this question in order to solve a problem that occurs to us after the the value allocation process. The problem is that after allocating the values, the source row changes its measure value to 0 instead of disappearing. Also, a destination row appears with the value of the measure that was previously in the source row.

I am going to explain this problem with an example. We have the following table:

We want to allocate values in the State California to the Country USA and values in the State Andalucia to the Country Spain. This would be the resulting table:

Instead, zero values appear in the table duplicating the initial rows:

How could we delete/hide rows with zero values? We do not really need them anymore.

Thank you so much in advance and sorry for the amount of questions this week!

Elisa

Attachments

capture.png (2.3 kB)
capture1.png (2.4 kB)
capture2.png (3.4 kB)