need expression

[#1]

Hi all,

     I have a scenario like these here i am having "week-sk" and "day_sk". i want to show for a particular week_sk the max day_sk

should be day1 and the second max day_sk should be day2 like that...here iam attaching the file

[swuehl]

Not sure if I understand, maybe just create a chart with dimension week_sk and as expression

=max(day_sk)

[MK_QSL]

=Aggr(Max(Day_sk),week_sk)

[#4]

Hello Kannuri,

Can you please look into the attachment.

Thanks,

Angad

[#5]

Hi,

Pls. Use  Aggr(Max(Day_sk),week_sk) in expression and week_sk in dimention.

Regards,

Mayank

[#6]

Hi Nagaraju,

Please find the below attached file for the solution.

Regards,
Santhosh G

[#7]

Hi Angad Singh,

    Thanks for your response but i want to show for the rank1 the days should be day5 and for rank 2 the day should be day 4.. like that

Regards,

Nagaraju

[#8]

Hello Kannuri,

Please find the attached solution.

We have rank the day twice to get the desired results.

Please let me know, if it meets your expected results or anything else is required.

Thanks,

Angad