Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table with 2 dimensions plant and material.
Plant has values FBPL, FCHI, F003, F005....
Plant | Material | F003 | F005 |
---|---|---|---|
FBPL | ABC | ||
FCHI | XYZ |
Now, in F003 column I want count of stock for plant F003 and material ABC ignoring FBPL. Similarly, stock for F005 and XYZ ignoring FBPL.
Kindly help!!!
Regards,
Rajeshree
You say that "Plant has values FBPL, FCHI, F003, F005". But this is not reflected in the table... You have some plant values as values to the left, and other plant values as column headers to the right. This doesn't make sense.
So you need to explain more what your requirements are.
HIC