Hi,
I have a stacked bar chart by country dimension and a Sales percentage measure ( calculated using two metrics, numerator and denominator) .
Each country bar is further stacked by another indicator dimension ( For e.g., Y and N) . So at for Country = USA we will have Y as 60 % on the bar and remaining 40 % as N.
The problem happens during the sort. I am sorting by expression DESCENDING on Country dimension . That expression is =$(eSales%) . The stacked bar chart doesn't respect the DESC order . Not sure how do I fix this?
eSales% is a variable and that calculation has numerator and denominator.