Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i want to get retail and wholesale contribution to another column. In my chart I have retail sale and whole sale in two rows.
as an example, if my retailsale=500 and Wholesale=1000, i want to get the contribution as retail contribution=(500/(500+1000))*100 automaticaly and same as whole sale contribution. how can I do this in a chart expression?
SUM({<Type = {'retail'}>}Sales)/SUM(TOTAL Sales)
and
SUM({<Type = {'wholesale'}>}Sales)/SUM(TOTAL Sales)
You can try both
with TOTAL and without TOTAL
UPDATE : Don't forget to go to number tab and select show in percentage%
SUM({<Type = {'retail'}>}Sales)/SUM(TOTAL Sales)
and
SUM({<Type = {'wholesale'}>}Sales)/SUM(TOTAL Sales)
You can try both
with TOTAL and without TOTAL
UPDATE : Don't forget to go to number tab and select show in percentage%
thanks