Monthly Archives: November 2014

Change the summary calculation of multiple pivot table fields at once using Macro (Excel)

Pivot table is useful to summary calculation for table. However, there isn’t a simple way to adjust multiple fields to the same function. The traditional way, you can right-click on the pivot table and adjust one-by-one. Fortunately, there is the¬†easy … Continue reading

Posted in Code | Tagged , , | Leave a comment

Resampling Data

Posted in Mathematics | Leave a comment