YTD Sales

[#1]

Hi all,

I would like to to find out the YTD Sales and show by Month

But I do not know what expression should I use.

As I have tried using different expression but failed.

Year	Month	Monthly Sales	YTD Sales
2012	01	200	200
2012	02	100	300
2012	03	300	600
2012	04	400	1000
2012	05	200	1200

I need help,

Thanks

[Sokkorn · Accepted solution]

Hi,

1. Load data

[Data]:
LOAD * INLINE [
Years,    Month,    Monthly Sales
2012,    01,    200
2012,    02,    100
2012,    03,    300
2012,    04,    400
2012,    05,    200];

2. Create Straight Table

     a. Years and Month as Dimension

     b. Two Expression

          i. SUM([Monthly Sales])

          ii. RangeSum(Above(Total Sum([Monthly Sales]),0,RowNo()))

See the sample attached file.

Regards,

Sokkorn

[#3]

Thanks so much:)