Calculation Dimension

[nihhalmca]

Hi All,

I need to create a calculate dimension as Top Vendors. like

Top Vendors

Top 10

Top 20

If i click Top 10 application should display top 10 vendors where i used vendor as dimension across application.

When i click Top 20 application should display top 20 vendors where i used vendor as dimension across application.

Regards,

Nihhal.

[ashfaq_haseeb]

Hi,

have a look at attached application.

Regards

ASHFAQ

[tresesco]

Calulated dimension: two expressions:

1. For top ten (use something like: if(aggr(rank(sum(sales)),vendors)<=10,vendors)

2. For top twenty (use something like: if(aggr(rank(sum(sales)),vendors)<=20,vendors)

Now use conditional enablement of these dimensions, use expression like:

1. =Max(If([Top Vendors]='Top 10', 1,0)

2. =Max(If([Top Vendors]='Top 20', 1,0)

Similarly with the help of set analysis, you can do it in the expression side also(conditional enablement of expressions).

Update: PFA

[PrashantSangle]

Hi,

Why dont you try with variable

Do like this,

Create one input box to allow user to set value i.e 10 or 20.

Use that variables in chart to display that much top Vendor.

     For that you can take Vendor as Dimension and then

     Go to Chart Prpoerty-> Dimension Limits->Limits->Show Largest->In Values (Insert Variable Name)

Or

You can create Two chart

one with Top 10 and another with Top 20

and based on selection display those chart

Regards

[MarcoWedel]

Hi,

one solution might be:

hope this helps

regards

Marco

[amit_saini]

Nihal,

This may help you, see the attachment.

Thanks,

AS

[nihhalmca]

Thanks for reply Mohammed.

I have gone through your application but my requirement is different, please see above my discussion.

Regards,

Nihhal.

[nihhalmca]

Hi tresesco, thanks for your response

i have seen your application, in application sum(value) chart has two columns as top 10 and top 20.

However my requirement is if i select top 10 in list, chart should show top 10 it is fine another thing top 20 it also fine, where i suspecting is if there is no selection at top vendors list. chart displaying top 10 and top 20 columns. actually i want to show without selection full data like one column as vendors. i hope you understand my question.

Regards,

Nihhal.

[nihhalmca]

My requirement was different.

[sujeetsingh]

Use dimension limit and  a variable to pass the value