Input box value into Expression

[#1]

Hi,

I have a chart that I am using to display the total magazine orders received by particular publisher alonsgide those for all publishers acheieved currently by using two expressions as follows:

sum({$<[Mag Publisher Name]= 'PUBLISHER_NAME'>} [Gross Subscriptions])

sum({[Gross Subscriptions])

Ideally I now want to be able to pass the value from an input box into the first expression so that the end user can pick which publisher to they want to compare the overall figures against. I have created a variable but can't work out it should be used!

Thanks in advance,

Will

[johnw]

How about this approach instead:

sum([Gross Subscriptions])
sum({<[Mag Publisher Name]=>}[Gross Subscriptions])

Then select the publisher like normal. One chart will show only that publisher. The other will ignore the publisher selection, show would show all publishers, or at least all publishers that match OTHER selections.