Set Analysis Query

[suresh_rawat]

Hi everyone,

Can you please tell me how to write this expression in Set Analysis.

Expression : =sum(total <State> Competitor_Data)

In Set Analysis..How????

[#2]

Hi,

Try like this:

=Sum({<State={"StateName"}>}Total Competitor_Data)

[suresh_rawat]

http://

Please refer the attached excel file in which Raw Data is available as well as outpur required is also available.