I have a calculation that fails within Excel 2010 when I select more than one date from my dimension . I have been told (by Deepak) that this is because Excel uses a subselect instead of a where clause (which Excel 2003 & earlier use). I have tested
this by saving a new file as an .xls then open it in compatability mode and create my pivot table as an older version; in this instance, my calculation is (mostly) okay. I was refered to this article for help:
Please see my next post for more info (as I have had formatting issues in the past with my first posts).
View Complete Post