LinkBack URL
About LinkBacks
I have a pivot table.I want to sort the same on part code who have book qty is greater than 0 ( zero ).Is it possible?
Pl.look attach file for more clarification.
I have a pivot table.I want to sort the same on part code who have book qty is greater than 0 ( zero ).Is it possible?
Pl.look attach file for more clarification.
Hihight the table, select pivot tool, and then select the sort button. Select the descending (or ascending if thats what you want), and then select the column you want from the dropdown
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
One option is to insert a new column named 'Book Qty>0' and add formula =E5>0. Filter on the new column. Then sort part code.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks