Pivot Table- Sorting Top 5 and one another value together

[AAP]

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

 

[Luke M]

See attached.

Used a tip from Debra, here:
http://blog.contextures.com/archives/2011/03/23/excel-totals-for-top-3-plus-other/

 

[AAP]

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.

 

[Luke M]

In that case, change the formula in F7 to:
=IFERROR(GETPIVOTDATA("Quantity",$A$3,"Brand","Others"),"")