Hello fellow communities,
Here I have and issue where i am required to categorize total quantity of particular item into their quantity range. When it's filtered and only 1 item is selected, it shows perfectly.
How can I sum the quantity by distinct purchasing document then group according to quantity range?
![](/legacyfs/online/203620_pastedImage_0.png)
But it's no purchasing document is selected at all, it will sum all the quantity and let it all be above 30,001.
![](/legacyfs/online/203621_pastedImage_1.png)
![](/legacyfs/online/203622_pastedImage_2.png)
How can I sum the quantity by distinct purchasing document then group according to quantity range?