Compiling Data from multiple source to Prepare Report

[rajibmahmud]

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

[v-yulgu-msft]

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

[rajibmahmud]

@v-yulgu-msft

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.

[rajibmahmud]

Can someone please help me with this????