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
Thanks
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