How we can calculate Year to date in straight table

[ferha_jafri]

Hello everyone,

I have a job as i have to calculate YTD data ,when i select YTD in multi box.I am be able to implement YTD in Graphs by using rangesum function but in case of straight table i cannot use rangesum the for straight table what should i do??

Thanks in advance

Ferha Jafri

[er_mohit]

write this code

for YTD

sum({<Date = {">=$(=YearStart(max(Date))) <=$(=max(Date))"},Year =, Month = >} Sale)

and see the attached application

[ferha_jafri]

Thanks for your reply Mohit i will try the following expression and let you know .