Kinsella, Joseph (Joey)

icon indicating a website link http://jotaki.github.io/

icon location C is probably my favorite programming language.

Results 4 comments of Kinsella, Joseph (Joey)

Pivot table with two data fields

This still seems to be an issue. Has there ever been a work around? what were other peoples solutions?

Pivot table with two data fields

I attempted to use ... in a working xlsx document, and got a similar result... I'm wondering if Excel doesn't like this for some reason? The issue I see with...

Pivot table with two data fields

managed to get a broken xlsx document to work by adding cache data and ensuring <colFields> was set in <pivotTableDefinition> Need to experiment a bit more, but I believe that's...

Pivot table with two data fields

<pivotTableDefinition ... dataOnRows="0" ...> <colFields> <field x="-2"/> </colFields> Seems to be the magic that gets it working. I'll be monkey patching my code to fix this, but it probably wont...