Pivot Table using Sheet Summary Report
I need to create a Pivot using a Sheet summary report as the only source file. When I go to the pivot builder I do select my report as a source, but once I move to "Assign Columns" I am not able to select any row / column / Value to populate the Pivot: if i click on "Add Field" it always shows "Empty" (which is not the case as my Sheet Summary Report has several columns).
Is this problem related to the type of report not supported by the Pivot app? If so, when will this be solved? Right now I am forced to copy/paste my report on a blank sheet to generate the pivot, which is not very efficient.
Thanks a lot for the help!