Forum Discussion
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
- Ashish_Mathur
Super User
Access Denied message.
- mohammedksaFrequent Visitor
Dear Mr. Ashish,
Please find the Link to download the file
- Ashish_Mathur
Super User
What exactly are you trying to share??? That is a 3.7GB .rar file? Sorry not interested.