Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i have a base with salesman (dimension) and sales (expression); with that base i do a tabel with all salesmen sorted descending in a top after their sales; near the sum of each sales i put a share (%) in all sales for each salesman
i want a slider 0%---100% in wich i want to select for example all salesman who are in fist 20% of sales; or the middle part like 30%--->70% (so only 40 percent from the middle) and to analize them
with the selected range in slider i want to do more analyses; so the table from example is only for you to see what the slider has to select
do you have any idea how to do that?
Thanks,
Cosmin
Use dimension limits and a variable. See attached example.
thanks,
it's a very useful answer but when i do the selection in slider i want the salesmen to be selected/filtered because i have others tabels,graphs in wich i want to study them
in your solution i put 2 variables; what is the expression which i have to use in table to do the sellection (i tried
$(v00) <>$(v01)) in dimmension limits - show only values...