One of the cool new features of Sharepoint 2013 is Excel Services with Field Lists. Previously, design of a pivot table would need to be done prior to publishing to the server. Now users have a way of designing self-service reports in the browser.
Drag and drop, self service reporting is here.
Kasper de Jonge PowerPivot Blog » Why SharePoint 2013 (ECS) is great for Multi dimensional!