Why Net Sale value(=MRP*NET QTY) calculate in Base raw file , Not using pivot Calculate field
Because:- Pivot first sum all mrp then sum all net qty and then multiply MRP*NET QTY
Below Example
RAW FILE
BELOW PIVOT SUMMARY
Why Net Sale value(=MRP*NET QTY) calculate in Base raw file , Not using pivot Calculate field
Because:- Pivot first sum all mrp then sum all net qty and then multiply MRP*NET QTY
Below Example
RAW FILE
BELOW PIVOT SUMMARY
