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
Top Solution Authors