Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
I am trying to create a data model where I am getting data from multiple sources.
The target is to get Brand & Channel level Income statement from below tables.
Currently I have Sales information at Product and Retailer level in Outlet level sales, in PNL Information tab I have Production Cost and Production volumn; from which I will calculate Production Cost per Unit.
In Trade Cost file, I have trade investment cost in 3 different sheet. In 1 sheet I have Trade cost at Product level, in another one I have Channel-Brand trade cost and in another I have National cost for trade. All this will create Trade investment cost.
Now I have to plot a file where I will be able to see the cost at Brand or Category level with Channel, where I will see Sales Value, Trade Investment and Production cost. For Trade cost at national level, cost to be allocated at a certain ratio I maintain.
Can someone help? Below files are reference.
http://fileshare.link/d78b64b5bc5c7ead/PNL_Information.xlsx
http://fileshare.link/9714dcb4419f4881/ProductHierarchy.xlsx
http://fileshare.link/924e93771e01d259/TradeCost.xlsx
http://fileshare.link/4359396ba52bb515/Outlet_Level_Sales.xlsx
Hi @rajibmahmud,
Could you please show us your desired output with examples? If possible, show us an image to make it more clear.
By the way, I cannot download the file from shared link. Could you please share sample files via OneDrive so that I can download or directly upload the .pbix file with dummy data.
Regards,
Yuliana Gu
I loaded the files in below link
https://1drv.ms/f/s!AuSkszFGzDQzjRuXa9iAHaAZ8UTO
My output would be Sales , Trade investment , Production etc in different layer with option to view in multiple angle. Its a simple PNL format I am looking for.
Can someone please help me with this????
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |