Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Guys,
Now I'm working on a report, the requirement is to display aggr values for each month and week as following
July | July | July | July | August | August | August | August | |
Week Number | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 |
Actual Value | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |
Aggr value | 1 | 3 | 5 | 9 | 5 | 11 | 18 | 26 |
Now I used following expression to display values but I don't know how to show it based on week and month:
RangeSum(Above(Sum("Actual Value",0,RowNo()))
Thanks!
Dotnetfan
May be you need this (if this is in a pivot table)
RangeSum(Before(Sum([Actual Value]), 0, ColumnNo()))
Resolve, thanks!!
Aggr(RangeSum(Above(Sum(Value), 0, RowNo())),"Month","Week")
Seems to work okay... what is the issue in the attached screenshot?
Is Week Number a dimension here too? How else are you making Month Repeat in the dimension?
May be you need this (if this is in a pivot table)
RangeSum(Before(Sum([Actual Value]), 0, ColumnNo()))
missing ')'
RangeSum(Before(Sum([Actual Value]), 0, ColumnNo()))
Hello,
Here is the source data
Column #1 is the month, #2 is week number, #3 is the expression and it looks doesn't work. Column #4 is the sum value and the last column is the expected output.
Month | Week | RangeSum(Above(Sum(Value), 0, RowNo())) | SUM(Value) | Expected |
7 | 27 | 325 | 325 | 325 |
7 | 28 | 327 | 327 | 652 |
7 | 29 | 385 | 385 | 1037 |
7 | 30 | 413 | 413 | 1450 |
8 | 31 | 299 | 299 | 299 |
8 | 33 | 385 | 385 | 385 |
8 | 34 | 365 | 365 | 365 |
8 | 35 | 1127 | 1127 | 1127 |
9 | 36 | 426 | 426 | 426 |
Is this resolved or are you still looking for help on this?
Not solved. Could you please help me with above data source? Really appreciated!
Resolve, thanks!!
Aggr(RangeSum(Above(Sum(Value), 0, RowNo())),"Month","Week")
Seems to work okay... what is the issue in the attached screenshot?