I have a issue with YTD,Where in the filter panel i have base year(Parameter) and month(parameter) as one of the filters.When i select jan then i am getting sales data as 10 and when i selected march month then i am getting 10+20+30 aggregated values of jan to mar.
The issue is i have target values for complete year and actual values till April.When i select September month then i am getting the difference i am not having the actual data for september but i do have target data.Showing blank values are also fine.
How can i achieve these please can someone help me out to resolve the issue. Thanks in advance.
Please attach sample data as twbx format.