Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
];
This do not work.
One of the chart uses pure sum as the measure
I have attached the screen shot.
Thanks
Vikas