Forum Discussion

mohammedksa's avatar
mohammedksa
Frequent Visitor
2 years ago

Income Statement using Matrix need to divide line item & sub Category by Sales Volume

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. 

 

 

3 Replies