Forum Discussion

Niraj_vora0106's avatar
Niraj_vora0106
Icon for Helper III rankHelper III
3 years ago

Grand Total logic

Hi community,

I need help in creating one logic.

In the snip below as you can see there are 2 Materials, PAM and PCM (metioned in row) and 10 Plants (mentioned in column) and Quantities as values.

 

I want to see only those Materials whose values (Quantities) Grand Total are negative.

Like in the snip we can see PCM's Grand Total is negative ie: -38

 

1 Material across Plant and 1 Material Quantity across negative.

 

 

Please help!