
Re: Accumulative sum sortbydimension problem
Stefan Wühl May 19, 2013 10:36 AM (in response to ernestina)It might be possible to do what your require like discussed here
Take care that the aggr() dimension values have same load order as the sort order you require in your table (Your month load order should be chronological).
If you can post a small sample, this will help us to help you with the syntax of the expression.
Hope this helps,
Stefan

Re: Accumulative sum sortbydimension problem
ernestina May 19, 2013 12:25 PM (in response to Stefan Wühl )Hi Stefan,
Thanks for your reply, and yes it was the same problem i'm facing.
I created sample and tried to put your sugested expressions (see the sample), yet it still didn't show the correct %of accumulation, both sorted by dimension(s) or not.
The expression(s):
1. my prev expression show correct % if not sorted by dimension(s)
=rangesum( above( Sum(actual),0,12) ) /rangesum( above( Sum(budget),0,12) )
2. this expression show the same result as no. 1 if sorted by month (111.
=aggr(rangesum(above(total sum({1} actual)
/ sum({1}budget),0,RowNo(TOTAL))),product,month)
/*
=aggr(rangesum(above(total sum({1} actual)
/ sum({1}budget),0,RowNo(TOTAL))),month,product)
*/
3. the other expressions not showing the result (NULL).

sample.qvw 163.2 K

Re: Accumulative sum sortbydimension problem
Stefan Wühl May 19, 2013 1:23 PM (in response to ernestina)Maybe like attached?
Changes 2 things:
 Load Order of month chronological
 expression to
=aggr(
rangesum( above( Sum({<month= >} actual),0,12) )
/ rangesum( above( Sum({<month= >} budget),0,12) )
,product, month)

comm82452.qvw 159.8 K

Re: Accumulative sum sortbydimension problem
ernestina May 19, 2013 2:15 PM (in response to Stefan Wühl )Thank you, Stefan.
Exactly what my app need it.



Re: Accumulative sum sortbydimension problem
ernestina May 19, 2013 1:57 PM (in response to Stefan Wühl )Hi again Stefan,
I forgot to mention that in my load order, it already sort/order chronologically by month 112, per product, as I copied in the LOAD * INLINE on sample. Thanks in advance.
