Forum Discussion

birdietran's avatar
birdietran
Frequent Visitor
5 years ago
Solved

[HELP!] Identify top 3 values summed based on another column

Hi all   I have a data table containing of the first 2 columns as below want to create a column chart showing: The top 3 CCY with highest lump sum amount while the remaining CCYs are accummulated u...
Need Help
  • Icey's avatar
    Icey
    5 years ago

    Hi birdietran ,

     

    Try this:

    Top_3_CCY =
IF (
    RANKX (
        'Outward Overseas',
        CALCULATE (
            SUM ( 'Outward Overseas'[Txn Amount in USD] ),
            ALLEXCEPT ( 'Outward Overseas', 'Outward Overseas'[CCY] )
        ),
        ,
        DESC,
        DENSE
    ) <= 3,
    'Outward Overseas'[CCY],
    "Others"
)

     

     

    Best regards

    Icey

     

    If this post helps, then consider Accepting it as the solution to help other members find it faster.

PC2790's avatar
PC2790
Community Champion
5 years ago

Try this if it works:

Top3 = SumX(TOPN(3,SUMMARIZE('Outward Overseas','Outward Overseas'[CCY],"ColumnName",[Txn Amount in USD]),[ColumnName],DESC),[Txn Amount in USD])

 

  • birdietran's avatar
    birdietran
    Frequent Visitor
    5 years ago

    Hi

     

    Thank you for your help. It didnt work though. I tried add a Top3 column and below is what I got :< :