Issue with ranked cumulative current-previous year sales

[m_wex]

Good evening,

Having an issue with ranked sales by material number and cumulative Current Year/Previous Year sales.

Attached is a sample dataset. 

https://1drv.ms/u/s!AnQQfxYxFNvukQijVc8dsTSxBEwo?e=t2NHAo

The issue is that when selecting all for the ranking the cumulative sales/profit graph is not showing all previous years sales.

I believe the issue is related to items sold in the previous year but not in the current year which is ranked. 

The issue also happens with the GM% by profit center table as the filter is ranked sales. 

Any help pointing me in the right direction would be greatly appreciated.

M_Wex

[lbendlin]

"I believe the issue is related to items sold in the previous year but not in the current year which is ranked. "

Can you describe what should happen in such a scenario?  Would you only want to rank items that have sold in both years?

[m_wex]

When all sales is selected for ranking, I was expecting that a normal previous year result would be returned.

Without ranking the previous year-current year numbers are correct (showing all sales) in both periods. But with ranking, only previous sales where there is a current sale is returned. So the overall previous year sales amount is not 100% of reality.

[lbendlin]

yes, agree with your observation. But I asked you what you plan to do in such a scenario.

[m_wex]

In such a scenario when all sales is selected, the complete previous year sales should be reported.