Looking for a quicksight “Insight” suggestion, how can I display top 3 carriers based on “ABSOLUTE” Month over month value, but display that carriers ORIGINAL month over month value?
E.g.
Top 3 carriers for Manifest are:
DAMCO with -2million
MAERSK with -1million
CMA with 0.5 million
(Keep in mind that the values can be positive or negative so I’ll create another calculated field that gives me the absolute values for these carriers, however sorting them by the absolute value is challenging if i want to display the original value on the insight)
Any help/suggestions will be appreciated! Thanks