Just testing out porting some 2010 reports into 2013 and found that Excel functionality has changed just enough to break them. Curious if someone might point out a solution:
1) Report is pulling from a SQL database and/or OData feed.
2) I have projects along the Y axis.
3) I have standard stage gates along the X axis.
4) Each cell should depict the date upon which each project will hit the stage gate.
In 2010, I simply set up the PivotTable and then set the cells to display the "Max" value of the date. After formatting the cell to appear as a date, it worked just fine.
In 2013, I get a message that I can't use the Max calculation with date fields in the pivot table. Effectively, this breaks the report. Is there an easy fix to this or do I need to break out some sort of combination of v and hlookups?
Thanks in advance....
Andrew Lavinsky [MVP] Blog: http://azlav.umtblog.com Twitter: @alavinsky
