I need to create a pivot table on a webpart page with multiple x dimensions based on list data.
----Status Started Completed In Progress ----Prio Hi Lo Hi Lo Hi Lo Task A 1 2 1 4 5 0 B 3 0 0 0 1 0 C 2 1 1 1 1 6
I've found the http://www.pentalogic.net/sharepoint-products/pivotpoint/ webpart, which is nearlly what I need, but only supports on x dimension (ie. no prio as in the example)
Does anybody now another webpart which can handle this? I currenlty don't have access to the enterprise license, but could maybe get access to it: - The excel viewer webpart would not be solution, as it requires a manual refresh of the connected list data, to get the view updated - would the performance point services have a suitable webpart?
I'm also open to any other suggestions..