1 Reply Latest reply: May 11, 2010 11:28 AM by Ricardo Reaño RSS

    urgent:  attach/detach chart

    Anil Konduri

      Hi,

      I have a pivot chart which is detached by default, and also I have few list boxes which allows to filter the chart. My question is how do I filter the detached chart when I select in list boxes. And if I click on chart, it should not filter.

      if the answer is macro, how?

       

      Thanks In Advance

        • urgent:  attach/detach chart

          You can use the Set Analysis to ignore the selections. For example, you have two filters "year" and "month" and you want "month" will be ignored, your expression in your chart will be:

          sum({< month= >} Sales)

          In Set Analysis, month= ignore all the selections on month.

          Regards,