Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have Sum(saleQty) in my chat column expression but i want to get only "retail" saleQty. how to use Sum(saleQty) and retail in set analysis to do the task. thanks
Sum({<Type = {'retail'}>}saleQty)
Here type is the dimension name which contains retails..
You can replace as per your field name
Sum({<Type = {'retail'}>}saleQty)
Here type is the dimension name which contains retails..
You can replace as per your field name
Hi Dushan
Sum({<YourFieldName={'retail'}>} saleQty)
best regards
chris
try this
Sum(<Fieldname='retail'>saleQty)
or try this
Sum({<Fieldname= {'retail'}>}saleQty)
thanks both of u
another thing, 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?