are you saying that A101, A103 and A107 have a null [Age Client]? or how are they falling outside the range? If any of those values has an age client it will be caught in your expression and renamed to A102 or A104 accordingly
a bit more info would be good on how your fields are linked and how the data looks
if it is the case that the age client is null for those 3 you will need something like
IF([Age client]<18,'A104',If (isnull([Age Client]),[Category])))
Hi Joe and Shubhu,
Thank you for your replies.
@Shubhu I would prefer not to push from excel but add the dimensions within the chart based on expressions.
For more details I have attached the QVW file. Any thoughts are appreciated.
QVforum.qvw 164.0 K
from looking at your qvw it seems you are trying to duplicate up your values so that they appear in the expression both for the calculated A102/A104 and then your standard field values too, I'm not sure if this can be done with just a simple calulated dimension alone.
If that is what you are after I would agree with Shubhu, you need to do the calculation in your data load so there is the extra line in category and revenue for you to use.