Data incorrect when using YTD of month

[#1]

Hi

I have Month as dimension and sales as measure

I want to display data as per YTD of Month

Suppose Month=01 means data till 01

Month=02 means data of 01 and 02 etc

I have tried creating an excel like

Month     YTD

01            01

02            01

02            02

03            01

03            02

03            03

like this

Now I can see the continuity of line chart from starting month to the month selected

But the problem is its always a straight line

The chart shows value of sales for all months as the value of sales for the month selected

like

Month Sales

01       20

02       25

03       15

If I select 03 as Month the chart is like a straight line showing all values as 15

If I shift to 02 as Month the chart is a straight line showing all values as 25

What am I missing?

Any help please

Thanks in advance

Priya

[#2]

Hi,

I hope this helps u.

Stefano.

[jonathandienst]

Priya

I think you should be linking your sales to the YTD field, rather than the month field. And make sure that your expression is sum(Sales)

Hope that helps

Jonathan