What if I want to use a Window function (partition by) in my SubQuery? It only allows me to do that in Top Level. Not sure if anyone has a workaround.
It works in queries and subqueries. You must have something else messed up. Do you have ordering (in the calculated field) set up on the subquery? You can only order on the top query.
You’re right. I have ordering to get Running Sum, probably that’s the reason. I ended up using filter in my Dashboard instead to hide unwanted rows based on the calculated fields.