Hello,
I receive sales reports on daily basis and I need to analyze the received data.
It's mainly 2 reports one of them is the sales and the other is the sales returns.
Both of them have exactly the same structure which looks like this:
Excel 2010
<tbody>
</tbody>
sales quantity - sales returns
and the same for the bonus quantities.
I created a new file with connections to the 2 files that I receive and tried adding a new measure and adding a new calculated column in the powerpivot but that results were wrong.
Any help will be appreciated.
I receive sales reports on daily basis and I need to analyze the received data.
It's mainly 2 reports one of them is the sales and the other is the sales returns.
Both of them have exactly the same structure which looks like this:
Excel 2010
D | E | F | G | H | |
---|---|---|---|---|---|
1 | Month | Customer Name | Product Name | Sales Quantity | Sales Bonus Quantity |
2 | Jan | Customer 1 | Product 1 | 1 | |
3 | Jan | Customer 2 | Product 2 | 99 | 45 |
4 | Feb | Customer 3 | Product 3 | 3 | |
5 | Feb | Customer 4 | Product 4 | 22 | |
6 | Mar | Customer 5 | Product 5 | 2 |
<tbody>
</tbody>
Sheet1
I need to get the final sales which is:sales quantity - sales returns
and the same for the bonus quantities.
I created a new file with connections to the 2 files that I receive and tried adding a new measure and adding a new calculated column in the powerpivot but that results were wrong.
Any help will be appreciated.