How to return the first and last times from timestamps in a Microsoft Excel PivotTable Your email has been sent The article How to return first and last times from timestamps in Microsoft Excel uses ...

Back in 2016 I wrote the following blog post about changes to the way Excel 365 generated MDX queries for PivotTables connected to Analysis Services, Power Pivot/the ...

How to calculate a conditional running total using a PivotTable in Excel Your email has been sent An expression to return a simple running total in Excel is easy — a few references and you’re done. A ...

Please note: This item is from our archives and was published in 2018. It is provided for historical reference. The content may be out of date and links may no longer function. Because the field names ...

Several readers have submitted questions about Excel 2010 and 2007 PivotTables, as follows: Q1: Why does Excel insert the GETPIVOTDATA function into a formula when you use the mouse pointer to refer ...

Controls the sort order of fields in the PivotTable Field List. When this property is set to True, the fields are sorted in ascending order. When it is set to False, the fields are sorted in data ...

Liam Bastick looks at the new PivotTable enhancements and updates in Office 2019. PivotTables were enhanced beyond recognition with the advent of Excel 2010 and Excel 2013, and the introduction of ...

PivotItem Required PIVOTITEM The member from which the drill up is performed. PivotLine Optional Variant Specifies the line in the PivotTable where the operation starting member resides. In cases ...

Have you found this content useful? Use the button above to save it to your profile. This is the sixth and final part of Simon Hurst’s series looking at the changes and new features in Excel 2016.