Grouping by month, quarter and year

building reports webintelligence
1

Hi,

I need to group the dates into month, quarter and year.

                    Amount

Jan2009…2
Feb2009…3
Mar2009…4
2009Q1…9

Apr2009…4
May2009…5
Jun2009…4
2009Q2…13

Jul2009…7
Aug2009…6
Sep2009…4
2009Q3…17

Oct2009…5
Nov2009…5
Dec2009…2
2009Q4…12

2009…51

I have all kinda dimensions from the universe like month name, year, week, date etc…

How do I get this kinda grouping?

Thanks in advance! :slight_smile:

thatsallfolkss (BOB member since 2010-02-16)

2

Reading the help files on quarter() and year() would be a start.

if [Date] is a variable and equals 16/03/2010 then

quarter([Date]) returns 1

year([Date]) returns 2010

Monthnumberofyear([Date]) would return an integer of 3

whereas month([Date]) would return ‘March’ as a result.

You can’t sort data in a report by month name - only monthnumberofyear()

That is unless you have some very odd report recipient who wants to see monthly data in alphabetical order…!

SteveD :uk: (BOB member since 2009-11-02)