Kig figure Display Requirement in BEx
I have a Bex report for Buffer Norm where I have two keyfigures.
1. Maximum Stock Level and 2 Closing Stock
In the report the Maximum Stock level keyfigure is displayed as an aggregated value while the closing stock is okay.
On analysis i found for every material there are four entries of record rows. I need to display only one of them in the report as such to pick only that record for the material where closing stock is not zero.
Attaching the screen shots.
At Cube level:
At Report Level
Need to show:
Maximum Stock Level = 65 and Closing stock = 57
Can you suggest how to pick only those required values from the cube.
I was thinking to use exception aggregation for the keyfigure Maximum Stock Level. But no idea how or if it will work.
Thanks and Regards