So, i have this problem to solve, i hope you guys can help me with.
I have this chart:
Year, Month, Product, Origin and Destination are dimensions. Days to Delivery is an expression that I only get the dimension that I created in the script (attached).
I want to create another chart with the TOP 5 "Days to Delivery" lines. So, in that chart, I would automatically have the top 5 most days to delivery.
I need to have another chart for that and cannot only be the maximum value of 5 in the "presentation" tab, because, later, I will have to expand these top 5 with other dimensions. Therefore I need to have another chart that shows me automatically (because these values can change daily) only the TOP 5 lines (Year, Month, Product, Origin, and Destination) of the "Days to Delivery". It would be like these:
I attached the QVW and the Excel file that I used for the dimensions.