Usage of Single field in Dimension and Measure both
I want to compare Stock quantity against the minimum stock level defined. But the sum of Stocks having different categories and like in progress , spare , in inspection etc. and that is too at multiple storage locations in same plant. like Storage location A , B , C and i want total stock of Single material according to storage location and compare to minimum stock level . If Total stock > minimum , Stock is in GREEN else RED. Final requirement is total no. of materials in GREEN and RED