I found the web.config route practical (attempted to incorporate it to The solution but isn't going to appear to have been approved so submitting below)Take note: You can not conditionally structure fields from the Values space of a PivotTable report by text or by day, only by number.Optionally, alter the selection of cells by clicking Collapse Di