Hi.
1
I did not get him to sort the pivot table. I wish that the values are ranked from highest to lowest percentage ... I even can do it, but when I change the filter dynamics, the classification is not updated.
2
As you can see in the model, there are several columns with values at 0% ... is there any way to hide these columns (or hide just remove the label) that are at 0%?
Last edited by marreco; 06-30-2012 at 02:53 PM.
"No xadrez nem sempre a menor dist?ncia entre dois pontos ? uma linha reta" G. Kasparov.
If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select b from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
Like this attached?
If your data was a better table you can filter the Row column and only show what you want. Because of your table structure you need to simply remove them manually.
If you had a correct table you would use Value Filters for your Rows. See http://www.pivot-table.com/excel-piv...ot-table-field for a demo.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Hi..
Can you sort?
Thank you!!
Like this?
Hi.
Great!!!
Thank you!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks