Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
I am using one slider and one pivot table in my Dashboard. My requirement is If user select 3 in slider then chart will show only first three States in chart. Please find sample qvw in attachment. Please suggest.
Hi
Use a calculated dimension for State:
=Aggr(If(Rank(Sum(Sales)) <= vSlider, State), State)
See attached
HTH
Jonathan
Any suggestions Please?
Hi
Use a calculated dimension for State:
=Aggr(If(Rank(Sum(Sales)) <= vSlider, State), State)
See attached
HTH
Jonathan
Hi,
Try this logic and develop your report
You have to use Rank() in dimension to show row as per selection in slider
In your Slider when user select any value that value set to variable and you have to use that variable in
Rank() to limit rows.
Regards