Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a listbox and a chart. when i select one dimension from listbox accumulation is working fine
But when i select multiple dimensions in Listbox am not getting accumulation for the results. how to make accumulation possible for multiple selected dimensions.
Thanks in advance
Will you able to provide mochup application to investigate?
What expression are you using today?
Hi
I am using expression same for both Sum(sales)/rangesum(sum(sales)) full accumulation option enabled for this , even i tried function
RangeSum(above(TOTAL sum(sales),0,RowNo(TOTAL)))
Sum(sales)/rangesum(sum(total <"MDQ SW Threshold">sales))
These functions are working fine for single selection but not for multiple selection. if i select multiple dimensions in listbox then Acc% is giving me same data as of Amount of rec column i.e no accumulation only percentage(shown in screenshot)
You are using this expression?
Sum(sales)/RangeSum(Sum(sales))? This should give you 1 for each of your dimension? RangeSum() is not even doing anything here.... I am not sure I understand your expression