Hi All,
I am writing a query where I need to display the Top 10 materials (as per sales data). I did this by using condition.
Also I need to display the ranking. For this I used the same KF and displayed it as ranked list.
But now I want to create an APD and take this query as the base query.
I wanted to know if my transactional ODS will have the ranking as query data?
I would need this to write the final query where I need Branchwise YTD sales of the Top 10 ranked materials. This sales value should be displayed as the % sales of that ranked material as a percent of the total sales of the Branch.
Please advise.
Thanks and warm regards,
Sharmishtha