Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have requirement to get the values
Month | SalesGroup | #Sales |
Jan 2010 | SYA | 1 |
Jan 2010 | SYE | 185 |
Jan 2010 | SYM | 562 |
Feb 2010 | SYA | 1 |
Feb 2010 | SYE | 143 |
Feb 2010 | SYM | 571 |
expected results is Sales Group has to be accumulated to each group SYA for each period -shown values in the #Expected Results Column
Month | SalesGroup | #Sales | # Expected Results |
Jan 2010 | SYA | 1 | 1 |
Jan 2010 | SYE | 185 | 186 |
Jan 2010 | SYM | 562 | 748 |
Feb 2010 | SYA | 1 | 2 |
Feb 2010 | SYE | 143 | 328 |
Feb 2010 | SYM | 571 | 1133 |
I tried
rangesum(above(count(distinct Sales),0,RowNo()))
I have option to select SalesGroup in the layout.
Advance Thanks for your help.
HI,
I hope this application helps you out.