rank

[raadwiptec]

Can we rank based on each dimension

for example.: I have a straight table with Cyclic Dimension and Sales Amount.My cyclic Dimension has the following below dimension.

Product

Product ID

Country

Sales Person

..

few more

So for example if i select Product | Sales Amount -- > The Sales amount should be ranking based on the top sold product

If i select Sales Person -------->The Sales amount should be ranking based on the top sales done on the Sales person

once i change the dimesnion it should be able to rank it.. i have totally 7-8 dimesnions which i would rank..

[vinieme12]

I assumed the OP is trying to achieve a calculated dimension , if he had already tried rank in expression this post would have been out of the question.

Just an assumption!

[sunny_talwar]

Now that would make a lot of sense.

[raadwiptec]

Hi vineeth

the groups was created at the front end.. in the chart. How can i make a variables in the script?

[vinieme12]

Why do you want to create this variable in the script though?

SET VGroupselection  = GetCurrentField([GroupFieldName]) ;

[raadwiptec]

ok vineeth got it.. i will test it