maximum value in ui

[s4ni9r]

Item	URL	Style	Sales
10012	Image1	NY30	1000
10013	Image2	NY30	550
10014	Image3	NY30	4000
10015	Image4	NY30	3000
10016	Image5	NY30	10000
10017	Image6	NY30	450
10018	Image7	NY30	360
10019	Image8	NY30	4000

need image corresponding to the max sales.

For each style there will be multiple items

[s4ni9r]

i need the image corresponding to the max sales , not max sales

[Data_Vizz_Pro]

Hi There,  Please find below the expression for the max sales image and make sure that include zero value is unchecked in the Data handling section.

---

Measure Expression: If(Rank(Sales,1,1)=1,sum(Sales))

---

---

//Load Script

[Data]:
LOAD * INLINE
[
Item,URL,Style,Sales
10012,Image1,NY30,1000
10013,Image2,NY30,550
10014,Image3,NY30,4000
10015,Image4,NY30,3000
10016,Image5,NY30,10000
10017,Image6,NY30,450
10018,Image7,NY30,360
10019,Image8,NY30,4000
10020,Image9,NY31,9000
10021,Image10,NY31,4000
10022,Image11,NY31,9000
10023,Image12,NY31,2000
10024,Image13,NY31,2000
10025,Image14,NY31,6000
10026,Image15,NY31,5000
10027,Image16,NY31,4000
](delimiter is ',');

---

DataVizzPro

https://www.buymeacoffee.com/data.vizz.pro
https://www.fiverr.com/data_vizz_pro

---