see the attached
Your book does not contain a date field so the first step is to create a date
next set the default date fiscal year start to July
it will return this
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
YTD_v10.2.twbx 34.2 KB
Thanks for the reply.
how do i make the single select on the month filter and still see the running sum numbers.
the minute is brought the buying group and made single select on the month filter , the running sum shows the absolute number against the buying group.
The idea is, view will only show buying groups and the running sum (month selected in the filter to the july month of previous year) next to it as the value with single month being selected in month filter .