Show top 3 and group rest values.

Anything related to PowerPivot and DAX Formuale
misqadv
Posts: 3
Joined: Wed Jan 10, 2018 12:31 am

Show top 3 and group rest values.

Postby misqadv » Wed Jan 10, 2018 12:34 am

Hi,

Im looking for the way to show in pivot table top3 max values (i.e. top 3 countries with biggest revenue) and group other countries in one cell. This thing will be used in monthly reports, so it will be good to make it atomatic. Is it possiable?
I will be very grateful for all your help.

BR,
Michal

P3Tom
Posts: 6
Joined: Tue Jan 09, 2018 4:20 pm

Re: Show top 3 and group rest values.

Postby P3Tom » Wed Jan 10, 2018 2:31 am

Please advise what version of Excel you are using (or if you are using Power BI Desktop).

Also, always helps if you can provide a some sample data in a workbook. Does not need to be much, only enough to show your case.

misqadv
Posts: 3
Joined: Wed Jan 10, 2018 12:31 am

Re: Show top 3 and group rest values.

Postby misqadv » Wed Jan 10, 2018 6:01 pm

Hi,

Im using Excel 2016. I've added attachment with workaround that I currently using, All of this is need to creat one chart. In all of my other reports I've already implemented PowerPivot.

Thank you all for your help.

BR,
Michał
Attachments
Power Pivot grouping top 3.xlsx
(24.89 KiB) Downloaded 33 times


Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 3 guests

cron