Forum Discussion
Count rows in query editor before applying filters
I'm not sure what you would envision as elegant. You could create a custom column in the query editor that would utilize Table.RowCount function and put that step before any filters. You could also create a separate query and all it does is do this, if you want it in a separate table. Again, not sure what qualifies as elegant.
Community ChampionI'm not sure what you would envision as elegant. You could create a custom column in the query editor that would utilize Table.RowCount function and put that step before any filters. You could also create a separate query and all it does is do this, if you want it in a separate table. Again, not sure what qualifies as elegant.
Hi, thanks for the reply, I'll take a look at doing a custom column. I was hoping that there would be something I could do with one query, rather than creating multiple queries to get to the result I'm looking for.