hello,
as dataset I have orders with a specific volume and that they belong to specific sector. with the filter I want to change the volume of the order and see the percentage by sector.
Example:
percentage of orders with Volume 0-max(volume= off course 100%
but then if I filter it between 0 and 5 maybe is 45%[ (orders0-5)/totalorders] How can I make this?
then the question is that each sector has its own totalordes-> so somehow the denominator of the formula should be affected by the sector filter.
can someone help me 
Hi @remba87
You can try the following and refine by testing your case. The fields I have are different, so you need to adapt to your case
a. Calculated field to check for your Order Volume. I used the parameter value to determine if the number falls in the range at and individual order level. I created this as a boolean and used it as a filter
b. For your Sector wise you could just do a count of your orders leaving the group by open. The filters on Sectors should will automatically adjust the count
c. Final result
Regards,
Giri
2 Likes
It worked!!!
thank you!