A new version of ONLYOFFICE Desktop Editors, a free, open-source, and cross-platform office suite, is now available to download. If you’ve not yet found a reason to try this productivity powerhouse ...

EPPlus from version 7.2 can calculate pivot tables to extract data from it and also to use the GetPivotData function. ExcelPivotTable.Calculate(refresh) Calculates the pivot table. Parameter 0 - if ...

Sagar has been writing about technology for over half a decade. An MBA grad, who worked for a top MNC in London, quit his job to pursue his passion for technology. Since then, Sagar's work has ...

I am a big fan of using Excel cube functions for reporting on Power BI datasets, Analysis Services and Power Pivot: they allow for a lot more layout flexibility than PivotTables when building reports ...

We’ve all met them: the users whose idea of a ‘report’ is a large table of data dumped into Excel. However many beautiful data visualisations they see, however many times you try to convince them of ...

Although it is not the most glamorous of apps in Google's vast catalog, spreadsheet editor Sheets is being tweaked to make larger data sets more digestible. At the most visual level, users will be ...

From the Not Just Numbers blog: It's been a while since I covered GETPIVOTDATA on the blog, so I thought it was worth a re-visit, but with the specific objective of demonstrating a structured approach ...