Calculated Dimension

[mohanrajsubrama]

Dear All,

I have date column  for 4 years and its respective sales.

Now my requirement is if my date column having values for entire year ie(till 31/12/2014)

then i need a extra row saying 2014 YTD , it should add all the values till Nov 31st 2014..

If i dont have values for the entire year then i need a row saying 2014 YTD ,it should add all the values till oct 31st 2014..

Please find the attached Screen shot of the requirement

[mohanrajsubrama]

Hi Guys ,

Any update on the above requirement.

Regards,

Mohan

[tobias_klett]

Hi,

something like this?

Regards

Tobias

[mohanrajsubrama]

Dear Tobias,

Did u upload some thing?

Regards,

Mohan

[tobias_klett]

Hi,

yes the "ytd.qvw". I put it here again.

Regards

Tobias

[mohanrajsubrama]

Dear Tobias,

I am not finding any attched file in my end.

Regards,

Mohan