Dynamic Rpt - Supress Rows Based on Measure in 1st Col only
Posted: Wed Jun 14, 2023 5:25 pm
Hi there
I have a Dynamic Report with multiple nested rows, and 2 Measure columns.
For illustrative purposes, example as follows:
Row Dim1
Row Dim2
Row Dim3
Col Measure 1 (e.g. Sales Value)
Col Measure 2 (e.g. Description)
What I am looking for is a way for the report to run and suppress zeros based on Sales value only.
At the moment, as soon as I add the description column, I get all rows returned where a description is present. I only want rows to be returned where there is a Sales value (and for the description to be for those rows).
In Perspectives, using DBR (instead of DBRW) after the first column seemed to work. Does not seem to do the trick here.Any ideas?
Many thx
I have a Dynamic Report with multiple nested rows, and 2 Measure columns.
For illustrative purposes, example as follows:
Row Dim1
Row Dim2
Row Dim3
Col Measure 1 (e.g. Sales Value)
Col Measure 2 (e.g. Description)
What I am looking for is a way for the report to run and suppress zeros based on Sales value only.
At the moment, as soon as I add the description column, I get all rows returned where a description is present. I only want rows to be returned where there is a Sales value (and for the description to be for those rows).
In Perspectives, using DBR (instead of DBRW) after the first column seemed to work. Does not seem to do the trick here.Any ideas?
Many thx