Create View with CTE (Common table Expressions)

I want to create a view in SQL as tableau software do not support CTE function. May I know anyone out there knows how to create a view with CTE?

Currently, I am unable to add a view as I am using a MAXRECURSION (I am doing recursive btw). The error message is "Incorrect syntax near the keyword 'OPTION'."

I understand that the SELECT clauses in a view definition cannot include the OPTION clause and several other things.

Hence, how do I solve this issue? Help is greatly appreciated! :slight_smile:

can you post your work so far?