Pivot reports are great in 7.94 and 7.95 since they go directly to Excel and save the pivot report structure. But the fact that they are based on queries, that may contain duplicates is a limiting factor so only the most basic queries can be used.

I would like to be able to base more complex pivot reports an an export instead of just a query to fix the duplicate issue.