Skip to Content
0
Former Member
May 20, 2010 at 04:20 PM

YTD to monthly data

49 Views

hi experts

My client has new requirement.

Till today,he have Query showing YTD value.But from now onwards he want to see monthly value(I mean he specifically want to see data for that month...if we say sales of months Jan=1 Feb=2 Mar=3

YTD for Mar will be 123=6 this is shown in report but he wanna see Mar value i.e, 3)

In the query designer I noticed....in Key Figures Panel...he has both key figures...YTD VALUE and Monthly Value....is it enough

if I drag out YTD value and drag monthly value into Key Figures panel....WILL IT SHOW MOTHLY VALUE THEN?

Thanks and Regards,

SChand