Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
Sxbbb
Creator III
Creator III

I would like to add the top 5 'Total' red + the top three Tank Sum(QTY) highlights. of the day that was Top5

I have field ' Line',' Tank','  QTY' ,'Date'

Used to make a Pivot Table. 

Used Dimensions ' Group = Line and Date', ' Tank'

Used Expressions Sum(QTY)

Sxbbb_0-1687407188166.png

I would like to add the top 5 'Total' red + the top three Tank Sum(QTY) highlights. of the day that was Top5

I try this code But it's not correct.

Sxbbb_0-1687414842234.png

Result  But it's not correct.

Sxbbb_1-1687415775560.png

desired example

Sxbbb_1-1687407188211.png

 

I would like to add the top 5 'Total' red + the top three Tank Sum(QTY) highlights. of the day that was Top5

0 Replies