In our series “You Asked, We Answered” we address questions that pop up often on our Community page.
I know how to use the select function to select a time period e.g. SELECT [TIME. ‘FY13’].
However, I need to split my data by half years. Is there any way of selecting a half year or a group of months, e.g. Jan to Jun.?
Yes, you can select the total for H1 FY13, for example, by using: [select: time.’H1 FY13′].
This will select the total for the first 6 months of your fiscal year.