Entries by Roley Sykes

Pivot tables or SUMIFS in reporting

Like many people I both love and hate pivot tables with a passion. They are so useful in analysing data on a one off basis, but when the requirement is to get a series of complex reports out every month with basically the same structure from one set of data, a number of pivot tables […]