how to get the Non Cumulative value in Bex Query

198 Views Last edit Dec 03, 2016 at 03:42 PM 2 rev

HI,

I am create Bex Report based on the Infocube.

Cube Structure like.

Dealer ID Material Labour Rate Spare Rate

101 M1 100 200

101 M2 100 100

101 M3 100 200

101 M4 100 300

when create a Bex Query it's showing cumulative value.

I want result like this

Dealer Id Labour Rate Spare Rate

101 100 800

How to Get this result.