1 of 1 people found this helpful
The [All Metrics Selector] calc is the one you inserted part of above, right?
Set the addressing for your LOOKUP calc as usual. But make a separate calc for [Page Position]. Make it do its own thing.
Make one more calc.
IF [Parameters].[All Metrics Selector]='page position' then [Page Position Lookup Calc] else [General Metric Selector Lookup Calc] END
Use that final calc in the viz.
Thanks so much, Joe! My apologies for the delayed response; I was in the midst of work and on a deadline to get this problem solved. Your advice worked 100%; your a lifesaver.