Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Sorry for basic question..
Could you please check it and answer to me.. Please
Hi,
try like this,
method 1:
measure 1
sum(CorevalueA)/sum(CorevalueA)+sum(CorevalueB)+sum(CorevalueC)+sum(CorevalueD)
measure 1
sum(CorevalueB)/sum(CorevalueA)+sum(CorevalueB)+sum(CorevalueC)+sum(CorevalueD)
similarly other 2 measure
method 2: try to load cross table load (best approach)
CrossTable (Cat,Sales,2)
LOAD CorevalueA,
CorevalueB,
CorevalueC,
CorevalueD
FROM table;
and create pivot table then add Cat as Dimension and measure like below
sum(Sales)/sum(Total Sales)
sorry i can't do that
Could you check it ??
Hi,
try to use synthetic dimension
Dimension:
=ValueList('CorevalueA','CorevalueB','CorevalueC','CorevalueD')
Measure:
=if( ValueList('CorevalueA','CorevalueB','CorevalueC','CorevalueD')='CorevalueA',sum(CorevalueA)/sum(total CorevalueA +CorevalueB+CorevalueC +CorevalueD),
if(ValueList('CorevalueA','CorevalueB','CorevalueC','CorevalueD')='CorevalueB',sum(CorevalueB)/sum(total CorevalueA +CorevalueB+CorevalueC +CorevalueD),
if(ValueList('CorevalueA','CorevalueB','CorevalueC','CorevalueD')='CorevalueC',sum(CorevalueB)/sum(total CorevalueA +CorevalueB+CorevalueC +CorevalueD),
if(ValueList('CorevalueA','CorevalueB','CorevalueC','CorevalueD')='CorevalueD',sum(CorevalueB)/sum(total CorevalueA +CorevalueB+CorevalueC +CorevalueD)
))))
Hi 정훈 최,
Try like this
Script Load :
CrossTable(TypeCode, Value, 2)
LOAD
surveyNo,
"Age",
CorevalueA,
CorevalueB,
CorevalueC,
CorevalueD
FROM [lib://Connect/SurveySummary.xlsx]
(ooxml, embedded labels, table is arrangetable);
Chart Funtion
Dimension : TypeCode
Measure : Sum(Value)
This is look like the picture below
Regards,
Justin.