take seller in dimension and distinct count of material in measure. try to create bins with specified numbers or 5 as step size... it will resolve your query... or place your twbx file in this forum will try for other workarounds aswell...
Hello Suresh and thanks for reply,
I can't attach the twbx because is sensible data sorry. I know i can create bins but there a lot of ranges and values in the meassure, not only the ranges i writed in the example, so i need a solution more dynamic. Exist some way to bins a meassure using a calcute?
Thanks for your help,
As per your requirement you want bar chart with range as dimension and sales as measure.
seller is your dimension you want to include. So you can try scenarios as below:
take sales as measure , take your range calculation(here name is Bins) and
also include seller(here i have taken city) and uncheck show header for city dimension.
Hello Megha Gawali and really thanks for your answer!
Thats exactilly what i want but instead of a lot of bars for each range (or bins in your example) i just need one bar for each one with the total. I'm tried a lot of ways to do it but without success for now. Any idea?
Thanks a lot! It works perfectly!