Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have two pie charts on my sheet where one displays information based on selections on the sheet and the other is suppose to use those selections but modify the year selection to a year that the user will select from a input box. The problem is that when i change the value in the input box, the data in the pie chart is not updating. Below is the expression used in the second pie chart:
sum
({$<week_broad_year = {"=nYearToCompare"}>} GROSS_DOLLARS)The variable is nYearToCompare and it is set to a year (i.e. 2010). Thanks in advance for any help.
try: sum({$<week_broad_year = {"$(nYearToCompare)"}>} GROSS_DOLLARS)
try: sum({$<week_broad_year = {"$(nYearToCompare)"}>} GROSS_DOLLARS)
HI
Try like this
=Sum({< week_broad_year ={$(nYearToCompare)}>} GROSS_DOLLARS)
That fixed it. Thanks so much Gysbert.