Excel Pivot Table sort with hidden values [closed]

Excel Pivot Table sort with hidden values [closed]

References

Reference NO 1

http://www.excelforum.com/excel-general/508184-sort-pivot-table-using-hidden-data-field.html

Reference NO 2

http://forums.cnet.com/7723-6129_102-520794/how-to-sort-pivot-table-by-value/

Reference NO 3

http://office.microsoft.com/en-us/excel-help/display-or-hide-items-in-a-pivottable-or-pivotchart-field-HP005199384.aspx

Reference NO 4

http://office.microsoft.com/en-us/excel-help/filter-items-in-a-pivottable-report-HA010342516.aspx

Reference NO 5

http://www.techonthenet.com/excel/pivottbls/display_val2011.php

Reference NO 6

http://excel.bigresource.com/Hidden-columns-in-pivot-table-source-data-JGA0pMi6.html

Reference NO 7

http://www.globaliconnect.com/excel/index.php?option=com_content&view=article&id=158:excel-pivot-table-properties-a-settings-using-vba&catid=79&Itemid=475

Reference NO 8

#EANF#