Tag: PivotTable

  • PivotTable: Calculated Fields

    PivotTable: Calculated Fields

    Sometime, after you have made a PivotTable you realize you might want to do some further calculations based on the summary results. For example, After getting the total revenue of a company by each division, and the total number of orders for each division, then you might want to calculate the revenue per order -right…

  • Data Slicer and Timeline are Useful Reporting Tools in PivotTable

    Data Slicer and Timeline are Useful Reporting Tools in PivotTable

    Most of us know how to use a Filter in PivotTable, but do you know that there is an even better tool in slicing data in PivotTable?  Yes, there is, and the name is, well, Data Slicer. Along with the generic slicer that works for every column, there is another slicer that works specifically for…

  • How Advance do People Make Rental Car Reservations? The Result May Surprise You!

    How Advance do People Make Rental Car Reservations? The Result May Surprise You!

    Spring break is upon us. Many students of mine are heading to exotic location, and quite a few of them have reserved rental cars many weeks earlier. But here is the question: When do most people make rental reservations? A week in advance? Or, just a few days in advance? I have worked with a…