Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Certain non data rows to be hidden

Hi Gurus

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)

A 10

B 20

C 30

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

2 Blank

3 Blank

B 1 Blank

2 20

3 Blank

C 1 Blank

2 Blank

3 30

D 1 Blank

2 Blank

3 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?

regards

RD

Not what you were looking for? View more on this topic or Ask a question