Always Display Top 6 brands

[ipauldur]

Hi,

Assume that i have sales value by country, brand, productCategory, Year, Quarter and Month.

Now i want to display always top 6 brands based sales value in each different object (Bar chart dimension is Sales value bucket) based on the selection. They may need to see next top 6 brands also.For that we should have selection. I have more than 1000 brands. But at a time need to display top 6 brands in 6 different bar charts.

Please look at attached screenshot to know the format of display.

Let me know how it can be done. Thanks in advance.

Regards,

Durai

.

[sujeetsingh]

Try limiting dimension settings .

[#3]

Steps:

Define a variable e.g. vTopn

Use the variable in a slider object.

Now use the dimension limits as shown in the screenshot.

Thanks,

Ram

[ipauldur]

Hi Sujeeth,

Thanks for your reply.

It is already in different object. For example, we have brands A, B, C,&  D. Then first bar chart shows sales by sales range (Sales value bucket as dimension) for only brand A. Likewise showing for each brand in different charts. But i want to display top 6 brands (6 barcharts) based sales vales and selections) by default. They may need to see another 6 brands also. So this sorting has to be done in front end as we need to display based any selections. So if any idea please share to me.

Thanks,

Durai.

[vikasmahajan]

Try this

Vikas

[#6]

Hi Vikas, Can you kindly elaborate on the expression? especially the usage of "only" here?