hi i had a task to create a dimensional parameter showing with 2 dimensions (Region and segment) and one calculation with Top 5 products based on sales
selected region in “Select Dimension parameter”. Below to that parameter, user can able to see the Region dimension values
Similarly for the Segment dimension also.
the out put will be like this
here im able to achieve for region and segment by creating a calculated field
if [Dimension Parameter]="Region"
ELSEIF [Dimension Parameter]="Segment"
ELSEIF [Dimension Parameter]="Top 5 Products by Sales"
here im not understanding how to show the Top 5 Products by sales, i tried to create the Set by taking TOP 5 condition and i think its not the correct the idea its not working for as set is showing as a boolean value
can any one help me to create the Top 5 Products by sales as filter