Formula Help needed

material Produced qty Consumed qty %consumption

-

A11 4 2 2/15

B11 5 3 3/15

C11 6 4 4/15

-

Result 15

-

Hi Experts,

We have a report like this as per our business rule

%consumption = value of individual row in consumed qty/result of produced qty column.

result of produced qty column = SUMCT(produced qty )

We use SUMCT to get the result of produced qty and is used in the formula. The issue here is when we drill down and swap with different characteristics it is not bringing right results.

Any better solution to fix this issue is appreciated.

Thanks,

Varun.