Bar chart display top 5 positive and negative values remaining should be under others

[venkatasuresh]

Hi Everyone,

Here is my input bar chat

Input file

Expected output:

Expected outputPlease find the attached input QVW file

Thanks,

Suresh V.V

[sunny_talwar]

Try this

Dimension

=If(Match(Country, 'GERMANY', 'USA', 'INDIA', 'CHINA'), Country, 'OTHERS')

Expression

=Sum(Sales)

Sorting

Match(If(Match(Country, 'GERMANY', 'USA', 'INDIA', 'CHINA'), Country, 'OTHERS'), 'GERMANY', 'USA', 'INDIA', 'CHINA', 'OTHERS')

[venkatasuresh]

Hi Sunny,

Thanks for your quick response:),

The below Measures are not a static, Those are Dynamic 

example: 1. For Jan-2019 (GERMANY,USA,INDIA,CHINA ) are Top 5

                    2. For Feb-2019  may be ( SWEDEN,RUSSIA,USA,UK) will be in top 5 (We are not sure which country will be in the                           top 5 every month)

Thanks,

Suresh V.V

[venkatasuresh]

Hi Guys,

Any suggestions here !

Thanks,

Suresh V.V