How to make a chart expression independent of selections in a particular field

[#1]

Hi All,

I have an expression to calculate a sum:

Eg. Sum(Sales)

I want this expression to disregard selections in the fields A,B but dependent on selections in other fields.

How can I accomplish this?

Thanks,

Neeraj

[matt_crowther]

Set Analysis is what you need.

Search for 'Set Analysis' in the Help file and it will walk you through it - once mastered it's a very useful tool.

Hope that helps,

Matt - Visual Analytics Ltd

[Anonymous]

Sum({<A=,B=>}Sales)

[#4]

I guess it must be like this

Sum({ A=>,B=>} Sales)

Regards

Sravan

edit: oops Dinesh was a bit fast!

[#5]

Thank you Matt, Dinesh, Sravan for the prompt response.

I tried Dinesh's expression and it works

Regards,

Neeraj