Microstrategy removing rows with Zero metric values

Microstrategy removing rows with Zero metric values

If there are more than one metric and want to remove the rows with Zero metric values.

There are several ways to do this but I guess the easiest one will be creating a Metric which is the sum of all the metrics to be used in the report.

Such as Sum Metric = Metric 1 + Metric 2 + Metric 3 +...........

The Sum Metric should be included in the report and it can be controlled by any of the ways below:

1) Adding a view filter to the report where Sum Metric != 0 which will bring only non zero values

2) Creating a filter definition prompt with the Sum Metric, so that when the rpeort is prompted user cans elect Sum Metric value is >0 .

Or we can jsut had code the filter Sum Metric >0 if we want to pre-filter the report with non zero rows for all the metrics in the report.

We can also use the report limits with metric values >0 with an and condition between each metric condition,