I have two queries in the attached: Works, Notworks
I have designed them as a pivot table.
The "Show as Percent of Column Total" seems to be greyed out in the "Notworks" query and it is not greyed out in the "Works" query. I dont know why because I have taken the SQL and copied and pasted from "Works" to "Notworks" so they are identical
I have compacted and repaired and decompiled.
I imagine it is something simple but I have spent too much time on this.
Please see attached 2010 db and open the queries and show as Pivot and select the field [Percent] and try to "Show as Percent of Column Total" which is found in the Pivot Table Tools / Tools group on the far right. It is greyed out only in "NotWorks".