This project has moved. For the latest updates, please go here.

Possible to Group Columns in Pivot Table

Aug 7, 2014 at 8:14 PM
I've successfully used ClosedXML to generate a pivot table, but the question is: is it possible in ClosedXML to group a pivot table's columns — preferably by weeks? I cannot find anything on on how to do this on the Internet, or on the Documentation tab. I also couldn't figure it out looking through everything in the Intellisense/Auto-complete in Visual Studio.
Coordinator
Aug 7, 2014 at 8:22 PM
I honestly don't know. Pivot table support was added haphazardly by contributors and I forgot the details of it. =/
Aug 8, 2014 at 3:12 PM
Eh, it finally occurred to me I could just add a field to the table, have C# calculate the week date, and use that as the pivot column.