Set Analysis

[#1]

On selection of Year, Month (say, 2014,Jan) and Brand as WC01, i need to write set analysis as

Brand(WC01) value / Total Market Value of Wildcraft . with what expression i can achieve this?

Thanks

[#2]

Hi Aditi,

Try this expression,

sum({<Brand = {"WC01"}>}Value)/sum({<Market = {"Wildcraft"}>})

Hope this helps.

Regards,

Snehal Nabar

[#3]

Hey, thanks. i have written the same expression, it does work. But on selection of brand WR03, it should show me

value for brand / value for wrangler. ie1200/11700

I want to write a standard expression for selection of any brand

[#4]

Hi,

I think you want to use

Sum(Total <Brand,Market> Value) / Sum(Total <Market> Value)

hope that helps

Joe

[#5]

Well, I do want [sum(Value) for Brand / sum(Value) Market under which the same brand falls]

But how do i write an expression for this?

[robert_mika]

Could you attached your Excel data?

[tyagishaila]

Hi Aditi,

Plz try this

and let me know. If you don't get correct result, I will give you another solution.

sum(Total<Year,Month,Brand>Value)

/

sum(TOTAL<Market>Value)

Regards,

Shaila

[#8]

Basically i want to calculate market share of the brand.

[sunilkumarqv]

What you actually want to achieve by default 

In set analysis

Brand(WC01) value / Total Market Value of Wildcraft . will work alternatively other selections should trigger

Then you try like this ..

If(Getfeildselections(Brand)='WC01',sum({<Brand = {"WC01"}>}Value)/sum({<Market = {"Wildcraft"}>}),

sum(Value)/sum()))