Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
My Data would be like below
ProductNo,BRAND,Week1,Week2,Week3,Week4,Week5,Week6,Week7
TV-20220428,TV_YELLOW,39,18,13,29,16,11,60
TV-20220428,TV_RED,09,22,13,22,12,1,13
TV-20220428,TV_BLUE,50,12,08,12,17,16,10
Expected Output Would be like below
ProductNo, COLOR, Highest Sales
TV-20220428, YELLOW, 60
TV-20220428, RED, 22
TV-20220428,BLUE,50
This should be do frontend only
Thank You.
Regards,
ValiShaik
Hi,
If you want only in the front, you can use RangeMax(), like :
RangeMax(Week1, Week2, Week3, Week4, Week5, Week6, Week7)
For more reusability you can do on back end a crosstable and simply a Max().
Aurélien
Hi,
If you want only in the front, you can use RangeMax(), like :
use : Sum(RangeMax(Week1, Week2, Week3, Week4, Week5, Week6, Week7))
Regards,
Abdul
Hi,
If you want only in the front, you can use RangeMax(), like :
RangeMax(Week1, Week2, Week3, Week4, Week5, Week6, Week7)
For more reusability you can do on back end a crosstable and simply a Max().
Aurélien
Hi,
If you want only in the front, you can use RangeMax(), like :
use : Sum(RangeMax(Week1, Week2, Week3, Week4, Week5, Week6, Week7))
Regards,
Abdul
Thank you for your reply, your solution also works perfectly.
In my case sum function also should use to fix issue.
Appreciate your feedback & respond quickly.
Thank You.
If you have a lot of field beginning by Week (or what you want) and you don't want to list them, you can use:
RangeMax($(=Concat({<$Field={"Week*"}>} $Field, ', ')))