Hello,
I receive the "Cannot read properties of undefined (reading 'rows')" error when I try to create a pivot table. The model the question is built off of runs fine. The questions runs fine as a table, but if I try to make the table a pivot table this error pops up.
However, it runs as a table?
Any ideas how I can fix this? I have tried searching the Discussion Board and seeing similar posts with this error but I don't understand the fix or what caused it. I'm not a SQL expert so plain English please 
Usually this means the input columns aren’t set right and the query is returning no rows to the pivot. Check that the columns, rows, and measure are set properly in the pivot viz settings.
Thank you @dwhitemv
I don’t have any settings to change in the visualization setting for Pivot Table when I get this error. Any thoughts?
That would be the problem, the query as written isn’t compatible with the pivot table.
What do you want the pivot table to look like? That might help figure out how to write the parent query in a way the pivot can digest.
