Is it possible to write a query from a SharePoint .iqy that automatically gives me a tab that shows the raw data as well as a table with a pivot table?

The pivot table always needs to have "Employee Name" as a the row field and "Sum of Occurrences" & "Sum of Total Hours Used" as the 2 value fields.

I need to have the raw data on its own separate tab so that I can ensure that the input from the people creating the events on the SharePoint calendar is correct.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.