Restrict the dimensions in a graph to show only 5 values
I need to design a bar graph where it only displays top 5 weeks based on the year, quarter or any selection. How do I restric the graph to show only a limited set of dimensions?
Thanks for your quick response. This was really helpful for me.
I have a couple of more questions where I'm sure your inputs would matter a lot. This might be a little time consuming, my apologies for the same.
1. How do I restrict dimensions in a table? Dimension Limits tab does not show when my chart type is set to Table.
2. How do I restrict the Months (Text) to top 5 based on rank/order but I don't have Month_ID(Numeric) in my dimensions?
Example: Dimension has 'Month' (Apr, May Format). 'Cost' and 'volume' as my expressions. Now, I cannot sort and select top 5 months to be displayed in the chart. So I will have to use Month_ID (i.e. 4 for Apr, 5 for May) in the underlying data. But I cannot use it in the dimension or make it visible.
2. How do I restrict the Month_ID(Numberic) to top 5 based Sales Volume (Expression)?
Example: Dimension has 'Month_ID' (4 for Apr Format). 'Cost' and 'volume' as my expressions. Now, I need to sort and top 5 Month_IDs based on Sales Volume of each month.
Any help would be great. Thanks again for your help in advance.
I'm trying not to get involved in the time-consuming discussions. Especially if a follow-up is not from the same person who created the discussion. You have to start a new discussion - it will bring you fresh responses.
Just a hint: use calculated dimension that contains rank function.
