Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Aditi,
Try this expression,
sum({<Brand = {"WC01"}>}Value)/sum({<Market = {"Wildcraft"}>})
Hope this helps.
Regards,
Snehal Nabar
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
Hi,
I think you want to use
Sum(Total <Brand,Market> Value) / Sum(Total <Market> Value)
hope that helps
Joe
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?
Could you attached your Excel data?
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
Basically i want to calculate market share of the brand.
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()))