Hiding and sorting pivot table columns?

[ihayes]

Any hacks for hiding columns in a pivot table display?
Or any suggestions for sorting a pivoted dimension by the column totals?

[Cyril_MTL_Analy]

You could try and implement something similar to what we describe in this dynamic Top N tutorial which will sort the pivot according to a measure and not alphabetically.