How do I locate the SQL behind the Pivot Table?

@abhijit To see the results of the query you can run the pivot and check the trace, this usually has the query generated for the results set seen. You can also navigate to Request Profiler screen and turn on the logging, then run the pivot again and check the results from Request Profiler, this is pretty thorough.

From there if you want to use this query you’ll need to incorporate a customization, maybe a custom table or set of tables which can be used to generate a pivot, or maybe it could be done with SQL views (not really my area of expertise).