chart dimension limit

[#1]

Hi All,

I'm having a bar chart in which dimension is drill-down group of Month(in MMM-YYYY format) ->customer name.

User will select start and end date then the chart will display information between selected dates.

Here I have to display top 10 customer details. For this I used dimension limit where I limited it to 11. its displaying top 10 records and rest records are displayed as others.

Here the problem is when start and end date difference is more. The first dimension which is Month might have more than 10 values so dimension limit is applied on Month as well as customer. But I want this limit to be present only on customer name not on date.

Is there any way to achieve this?

Thanks,

Kavita

[shane_spencer]

Why not just have 2 seperate charts in a container and switch between the two, that seems more practical that a drill down group.

[#3]

Use a calculated dimension with aggr (rank...... <=10

[#4]

Hi Ramkumar,

Thanks for the reply.

Could you please explain what that calculated dimension does and give the complete expression?