Certain non data rows to be hidden
I have a query in this format
The key figires are aggregrated as per the selections A,B, C and D.
Each of these selecitons (A,B,C,D) are restrcicted to few A/C numbers.
Str Acc Bal (KF)
D No data
I have a free char of Account NUmber. When i drill down on account number,
I get the following format
Str A/C no Accbal(KF)
A 1 10
B 1 Blank
C 1 Blank
D 1 Blank
We dont want to see any blank rows which do not have data. We want to see only the rows of account numbers for which there is data.
Please advise on the possible solution scenarios.
The point here is that the user might drill down and only in such a case we want to hide the blank rows!
We are currently on BW v 2.1C. IS there an option in BW v 3.5 for this?