SVariable total function

[vikas_nandanwar]

Hi,

I have created SVariable 'mfg'

I have assigned 2 alternatives as

mfg = sum(Cts)

mfg = sum(Value)

I want to use % on total as -

1. - Sum(Cts)/Sum(Total Cts)

2. - Sum(Value)/Sum(Total Value)

My expression is not working.

$(mfg)/total$(mfg)

Thanks

Vikas

[jwjackso]

Try something like this:

Let vPct = 'Sum($1) / Sum(Total $2)';

DataSet1:
LOAD * Inline [
Dept,Val
D101,100
D101,200
D102,300
D102,400
D103,500
];

[vikas_nandanwar]

This do not work.

One of the chart uses pure sum as the measure

I have attached the screen shot.

Thanks

Vikas