percent_of_total Question

[kuopaz]

From the docs:
“percent_of_total calculates a cell’s portion of the column total. The percentage is calculated against the total of the rows returned by your query, and not the total of all possible rows.”

Say I have a query that returns 100 rows. I want to show the top 10, so order the column and then set the row limit to 10. But as said, the percentage is calculated on the 10 rows returned. Is it possible to get the percentage based on the original 100 rows, but still show only the top 10 rows?