Register
Log In
Unanswered
Home
December 29, 2016
Offline
Hi all,
I have a doubt: When I did a pivot table I can´t filter the item Value. I want to filter top 10 and then sort to Max to Min, but I couldn´t . Can you help me
Dashboards
Power BI
Power Query
April 21, 2015
Offline
Doesn't see a problem here.
Place cursor in cell with a name.
Tab where you find the sorting button (I work with Dutch version, doesn't know what the English name for that tab is).
Sort and then decending and click the right column name (see my image).
Works perfect. And after that you can also filter the way you want (choose 'value')
Dashboards
June 25, 2016
Offline
Hi Hava
SORTING
1) Click the down arrow on the Name header.
2) Select More Sort Options...
3) Select Descending (Z-A) by:
4) Select Sum of Valor and click OK
FILTERING
1) Select cell E3 (just beside Sum Of Valor header)
2) From the Ribbon select Sort & Filter - Filter
3) A down arrow will now appear on the Sum Of Valor header.
4) You may need to hide the Grand Total if you want to filter Top 10...
You can now filter on the Sum of Valor column.
Hope this helps.
Sunny
Most Users Ever Online: 57
Currently Online: Ali Bokhari
1 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Susan Booze
Rita Hrez
David Innes
preeti bhulabhai
Charles Klasek
Patrick Isedu
Emma Hayward
Vamseedhar G
NA NA
Max Neumann
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
