Rank Function w.r.t multiple dimension is not working

[abhaysingh]

Rank function is not working with multiple dimension please find the sample data as well

kindly help...........

regards

abhay

[tresesco]

What is your expected output?

[anbu1984]

Attached qvw has only one dimension. Can you attach sample data

[sorrakis01]

Hi,

First you need reload the file because dimension city isn't it.

Doesn't work because you don't have sales values in all the dimensions......

the same of Tresesco: What is your expected output?

Regards,

[abhaysingh]

e.g

Cust Name       Cust Code        Pre-Tax Value CY          Rank-CY          Pre- Tax Value LY           Rank-LY

AA                         01                              100                        3                               80                             4               

BB                          02                            120                         2                               130                            1           

CC                         03                                 80                        4                               90                              3    

DD                          04                                  150                     1                             120                           2

I WANT THE OUPUT LIKE THAT

[sorrakis01]

Hi,

Try this.

Regards

[anbu1984]

Use rank(TOTAL Sales)

[abhaysingh]

not working for multiple dimension

[anbu1984]

Can you post qvw which you tried

[sorrakis01]

Hi,

Then i don't understand you because the file make the same of your example.

Sorry and Regards