I have already tried this solution , the fact is i have Potentially 3 to 8 kpi and i can not create 8 Expression One For Each of my dimension values and i will have two more dimensions witch are used with conditional visiblity
3 dimension and maybe 8 expressions max, so 24 expression
may be this is an alternative...see Sheet1 in attachment. now, there are two options -
1. have 8 expressions in each of the two charts. - easiest to implement and shouldn't be too hard to maintain.
2. create a table with expression name and the actual expression in excel and read it in. then have a list box for expression name and you can update the two charts to display one expression at a time. easier to maintain.
edit: upon additional thought, i think option 1 is better as option to will need you to get a little creative.