BEx Structure issue
Hello BW folks ,
I have following issue ,
I have a structure in rows in the BEx designer .
This structure consists of following four areas,
1. Standard Type : when sales doc type = ABC and Item Category = Excluding XYZ.
2. 3 Rd Party : Sales doc type = ABC and Item Category = XYZ.
3. Rush Type : Sales doc type = PQR and no Item category restriction as Standard and 3 rd party.
4.Free Type : Sales Doc type = LMN and no Item category restriction as Standard and 3 rd party.
Now every order falls under only one of the above four areas like Standard, 3 rd part etc.
all are in rows and
we have Sales figure in Column .
For an order the sales figure is displayed correctly in the report .
But the problem is if the Order falls under Standard type then for all other areas like 3 rd party, rush ,free type is shows empty sales figures which is correct as these area's do not have sales figure when order is having standard type.
But the user do not want the Empty rows for Sales for the rest of the areas in which an order do not fall.
for example : if an Order 1234567 is having Sales figure
77888.00 EUR for standrad type then there will be four rows in the report out of which one row for Standard type will show Sales figure 77888.00 EUR correctly but the three additional rows will be empty.
The user do not want to see these empty rows in the report.
In summary the user wants only that row to be displayed in report for which an Order is having Sales figure in column and he do not want the empty rows for other areas.
Best Regards ,