https://drive.google.com/file/d/1owymynRhG_3hpmxG9KxJfrohobCVmIK8/view?usp=drive_link
Dear Experts,
I am preparing Income Statement related to Readymix Industry which has multiple location. I want to divide all the line items with Quantity sold to identify the cost per Unit( Cubic Meter M3). Income statement layout is perfect, Location with Slicer is working properly, Grandtotal include sales volume which i have excluded from Total, First issue were i am facing is dividing sales volume with all the line items and sub line items, Second problem is expense item are in Negetive and so the value divide are giving Negative value need to avoid Negative sign. I am enclosing the pbix file for ready reference.
Appreciate, Any one can assist me in finding solution.
Thanking you in advance.
