Pivot Tables seem broken

EVE Technology and Research Center EVE x Microsoft Excel Add-in
1

I have been using a Pivot Table to track daily sales from our Corp wallet for some time. This worked well until recently when due to sheet corruption I had to rebuild the tracking sheet.

The new Pivot Table is repeating every item label and no amount of changing settings or using the report layout menu under “Pivot Table Design” makes a difference.

For clarity, if we have 4x Pyerite transactions I want it to summarize them to one entry, but it keeps them as 4 distinct entries no matter what buttons I click.

Would love any input or suggestions

2

So I get to reply to myself here. Fresh eyes from my Corp mate figured out the problem

Looks like the raw import on the wallet (the stacked squares icon) was too unique for the pivot tables to process correctly. If you Sanitize using the =##.type or =##.name the simpler name labels work without issue.

1 Like
3

Glad you solved it. Using type id or name rather than cards is a good idea. Not always necessary, but doing it that way can save you some headaches debugging.