Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts
i have bar chart, dimension is master item dimension can drill down called product category, drill down to product group.
and measure is %sales vs last year. i would like to sorting bar chart by the current year's sales not %sales vs last year.
and don't display current sales in the bar chart. i already set product category sorting by expression. however , it is working in product category, it is not working when i drill down to product group. is there any way to realize the sorting problem?
Thanks in advance.
Select other dimensions in the dropdown and give the same expression which is you give to product category
hi
if you use a drill down master dimension
than you can set the sort for each level of the dimension
in the picture below , you can select the field from the drill down dimension ,in the box were is written Line Desc 1
Dear Lironbbaram
Thanks so much for your reply, solved my problem.