

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
RangeSum on line chart with 2 dimensions
Hello
got a line chart with 1 dimension called Category
I got a simply expression sum(man_days)
I want the cumulative sum so I used the rangesum(above(sum(man_days),0,rowno())) and it works fine
Now I added a new dimension called Division and I want to calculate the cumulative % of mandays per each division by category
the expression is now rangesum(above(sum(man_days)/sum(total<Division>man_days),1,rowno()))
the above expression doesn't work ( i mean no accumulation is made) checked rangesum(above(sum(man_days)/sum(total<Division>man_days),1,rowno())) it gives zero
I then tried aggr(rangesum(above(sum(man_days)/sum(total<Division>man_days),1,rowno())) ,CAtegory, Divsion) but didn't work
Kindly advise

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
RangeSum(Above(Sum(man_days) / Sum(Total <Division> man_days), 0, RowNo(Total <Category, Division>)))


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
rowno() doesn't take other than Total as parameter
please if you are not sure of the answer, don't post it
