Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
If you observe in below picture, i have a dimension 'Quarter and Year' and i have three different expressions stacked upon each other (i.e A Ratio, B Ratio, and C ratio). Now when when hoover on a bar the pop up label shows as below but i need a one more line in popup label saying 'Total Ratio' which sums up all the expression.
I tried summing up all the thee expressions in the label itself but its summing up all the data i.e 'Q4 20144' and 'Q4 2013', its not dynamically dividing upon the dimension. how can i achieve it without writing a new expression.
See attached
qvw pls?
Add another expression and customise it. Turn of pop-up labels in the presentation tab but enable text as pop-up only for that expression, and make it something like:
= 'Year and Quarter' & [Year and Quarter] & chr(10) &
'A Ratio: ' & [Your expression for your A Ratio] & chr(10) &...
etc. Or you can customise to your own needs.
I am new here.. am unable to attach the qvw in reply
I totally understand that. but if you add a new expression. it gives us new bar right? i don't want that.
here it is i have tried for first expression. you can check it
1 .click reply
2. on top right corner there option "Use advanced editor"
3. from bottom right said,there is option Attach
See attached
Than you very much
Not if you un-tick the bar and just enable text as pop-up as I mentioned, as charlotte showed in the example below!