Sorry, I know this is a simple question but I have brain fog today.
Using Webi 11 3.0
I have percentage figure against supplier activity and have created a dimension to band the performance together
=If([Percentage]Between(0;0.799);"0 to 79%";If([Percentage]Between(0.8;0.899);"80 to 89%";If([Percentage]Between(0.9;1);"90 to 100%")))
I now want to create a Measure which will show the total number of suppliers in each of those bands.
I would also like to show that total against different categories, so for example the number of Suppliers within a Food Category which are in the 80 to 89% band, in the 90 to 100% band etc
Thank you for any help in advance