• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Pivot Table- Sorting Top 5 and one another value together

AAP

Member
Need 5 top brand sorting with quantity and Others when making pivot tables(for accounting period Q1-Q3 2011 )
I need this output when sorting with pivottable, see file attached.
Brand Total
Asus 16,882
Samsung 12,958
Acer 7,506
HP 5,155
Packard Bell 4,669
Others 1,311
Total 48,481
 

Attachments

  • Pivot Sorting.xlsx
    19.4 KB · Views: 4
My problem was not the same, in my excel sheet there are many big brands products and others is a name for non-branded product.
 
In that case, change the formula in F7 to:
=IFERROR(GETPIVOTDATA("Quantity",$A$3,"Brand","Others"),"")
 
Back
Top