• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Min/Max of Date in Pivot Table doesn't work

Gene

New Member
Loved the latest tip from Chandoo on using Min and Max for dates in a pivot table! Problem is - I have files where sometimes this works and other times I get an error saying the pivot table cannot use Min/Max for the values.

I'm stumped as to why. Any ideas? A small sample file is attached.

Many many thanks!
Gino
 

Attachments

Gene

New Member
Thanks so much Chihiro! I was formatting the source as the date instead of the other way around! Much appreciated!
Cheers,
Gino
 

Chihiro

Excel Ninja
Likely. I just tested on Excel 2010 and no conversion needed (has PowerPivot & PowerQuery along with MySQL for Excel add-in).

While for Excel 2016 I needed to do conversion (has Solver Add-in, MySQL for Excel, Erlang for Excel).

Edit: I'll test it on Excel 2013 once I get home.
 

Chihiro

Excel Ninja
Ah, found the culprit.

The pivot table in Op's sheet is created via Data Model. With this set up, you either need to conversion after it's been loaded to PivotTable or there's additional transformation needed within Data Model.

If simple Pivot Table straight from sheet data, this additional conversion isn't needed.
 
Top