you-asked-we-answered

You Asked, We Answered: How to Select Half Years

Share this Story

In our series “You Asked, We Answered” we address questions that pop up often on our Community page. 

Question:
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.?

Answer:
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.

Leave a Reply