Set Analysis - Using Month, Year to Date and Annual Figure -wrongly displaying all months
I want display some financial information for the current month and the annual budget total in a chart (Straight Table)-
I want to display for individual accounts; the selected month; the year to date value for that month and also the annual value
One month has been selected and the total values coming out are correct but the table is displaying data for all 12 months - it is including each budget month individually rather than the total budget for the year
If I remove the month (GLPeriod.PeriodNum) dimension then the data is displayed correctly but I do need to include this field.
This expression displays the year to date budget for the chosen month: