Table Calculations without row limit

Hello,

I have a sales table by seller. I want to calculate percent of sold quantity by each seller. But when i try these as in the screenshot, "Percent of Sold %" column calculated based on row limit. 

Is there any way to calculate percent of column without row limit? 
2.38% ==> 12,927 / 457433. 
But i want to calculate: 12,927 / 518,985

9fdec31a-7cc1-41e7-b671-a32309a3fe0f.png

Thanks

1 REPLY 1

The only way to do that would be to aggregate the total sold before displaying the data, either PDT/NDT or an already available column in your model that is used in this explore. There’s no other way to bypass the row limit unfortunately

Top Labels in this Space