Recent content by bill9376

I think I've got a workaround, but it's not seed data, which would upset functions like count. Programmatically construct a range of intended pivotitems, build a p-cache on it, then change the SOURCEDATA of the cache to the report data and refresh the table. I've got a working prototype. I'm...

Actually I think you do. I tried grouping and it did not show months for which there was no data. Maybe it did it wrong? Also you don't get the control over grouping headings that you do with pivot items. Anyway I think I found a workaround, which I will publish if it pans out. Thanks for...

'Cut and paste this code into the WORKBOOK_OPEN of a blank workbook, save and reopen, 'for a demo of the following problem: ''''''''''''''''''''''''''''''''''''' 'I need a pivot field ("month") whose 12 items span a year, 'regardless of whether each month is represented in the source data. 'To...