How can I Filter out certain Time Periods in my Time Filter?

JR1010

Hello,

I'm trying to include the following time periods - Month, Quarter, and Year totals while excluding Half Year.

Because of other use cases I cannot remove Half Year from the time scale.

Has anyone encountered this before and how did you solution it? Thanks!

Arnab116

HI @JR1010 ,

From your requirement I could get that you need Month, Quarter, and Year totals and also the  Half Year Total in some use case.

First of all no need to exclude Half Year from Time Scale.

1. Create a Time System Module at Month Level.
2. Create a Line Item - Boolean Formatted("Half Yearly Only") and set it to true.
3. Change the Time scale to Half Year.(This can be used to filter out only Half Yealy Totals)
4. Create a another Line item - Boolean Formatted ("Exclude Half Yearly ") and set the Formula to NOT "Half Yearly Only"
5. Change the Summary to Formula.
6. Use this Line Item "Exclude Half Yearly ") to filter out all the periods like month, quarter and Year Totals in a module at month level and will help you exclude Half Yearly Total where you don't need it.

Hope this helps!

Thanks,

Arnab

rob_marshall

@JR1010

@Arnab116 is absolutely correct, here are some pictures explaining what Arnab116 did with the only difference I did not create a subsidiary view (I created another SYS module at the Half Year level), but both work. If this is what you are needing/requiring, please mark @Arnab116 post as answered.

Rob