Variable disappears when drill down in table chart
I have a variable defined as: v%Complete=MTD%COMPLETE
It's used in a table chart with the expression:
Num(Column(1) / Column(2),'#,##0%')-$(v%Complete)
The table chart has a drillable group. The variable and expression above work fine at the top group but the variable disappears after drill down. Any suggestions or advice is welcome. Thanks!
P.S. I also tried defining the variable using set analysis and that completely zeroed out the variable.
Right- there is no Region associated with MTD % because MTD % doesn't differ by Region or any other data field selections besides year, month and day. I want the selection of any field other than year, month or day to be ignored and not affect MTD % complete.
I can understand that, but this is not the way the data is associated. So the data most be linked in a way that MTD is available for all regions. If the MTD value is unrelated to the data it can also be left in a data island, which means there is no connection to the other data. This way it would always remain unaffected by other selections. Which way you go to resolve the relation will depend on your data and how it relates. I am afraid I will not be able to give you e perfect answer for that.
