Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am having following tables
Fact:
Brand Code,
Site_ID,
Sales
Site Brand Area:
Site_ID,
Site Brand Name,
Brand SQ.M.
Target:
Site_ID,
Site Brand Name,
Target/Sqm
Brand_Master:
Brand Code,
Brand
I would like to display, for Site_ID, Sales, and sum(Brand SQ.M.*Target/Sqm) where i want to use set analysis for Brand and Site Brand Name,
and I am using :
Sum(
{<[Brand] = {"=[Site Brand Name]=[Brand]"}>}
([Brand SQ.M.]*[Target/Sqm.])
cant work.
do one thing ... bring Brand code field for brand target table by applymap or left join ,
then concatenate brand target table with FACT on the bases of keeping the common field Brand Code
Hi Vivian,
Try this script..
Sum(
{<[Brand] = {'$(=[Site Brand Name])'}>}
([Brand SQ.M.]*[Target/Sqm.])
)
Hi,
Try this
Sum(
{<[Brand] =p( [Site Brand Name])>}
([Brand SQ.M.]*[Target/Sqm.])
)
Hope it may help....
HI, Saranya,
It result in Total Target Amount. But not divided according to Brand.
Thank you
Hi Vivian,
Did you try this
Sum(
{<[Brand] = {'$(=[Site Brand Name])'}>}
([Brand SQ.M.]*[Target/Sqm.])
)
Can you provide you sample qvw please...
Hi Vivan,
Try this expression with Aggr() like below:
sum(aggr(Sum(
{<[Brand] =p( [Site Brand Name])>}
([Brand SQ.M.]*[Target/Sqm.])
),[Brand]))
Hope it will help....
HI Rajat.
thank you for your reply.
I have tried that before. It doesnt help me.
and I dont have sample data or qvw
thank you
can u share your qvw file
tat will be easy to identify the prob.....