Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, i need help for this:
I have this table, and i need to create a multibox, with 2 values ( 1. Selecting the posives ,2. Selecting the negatives)
Is this posible?
Num | Num PY | Delta | Delta Pax % | |
a | 685 | 738 | -53 | -7,2% |
b | 364 | 347 | 17 | 4,9% |
c | 253 | 302 | -49 | -16,2% |
d | 234 | 224 | 10 | 4,5% |
e | 196 | 153 | 43 | 28,1% |
f | 157 | 107 | 50 | 46,7% |
Total | 2.490 | 2.567 | -77 | -3,0% |
Thanks
yes if you create an expression :
Hi,
You can put two expressions in different Mutli-box's like
If delta < 0 for negative values
and
If delta >0 for positive values
Regards,
KC
If you want it as one selection, create an expression as suggested and write:
If(Delta >= 0, 'Positive', 'Negative')
Which should give one selection of either positive or negative that will filter your delta values.
If you want them as separate drop down selections, you could have the actual values by writing:
If(Delta >= 0, Delta) and If(Delta<0, Delta) as two expressions.
The problem is that this table box has a Dimension, so if i put in a separte object the multibox as positive and negative, this does not work
Thanks
A table box is a complete list of all data related to the fields you enter, so this shouldn't stop it from working.
Even if you had a straight table chart and had a dimension, it would still work. What's the exact problem you're facing? Can you post an example? Because any of the options above should work unless your delta field isn't an actual field and is a calculation of another value?