how to calculate and display measures by month in webi

building reports webintelligence
1

Hello All,

I am posting for fist time in BOB but have been viewing experts posts since longtime.

I have a webi report with single query which brings data for 2010 YTD and displays dates from jan-june in date format (ex: 05/12/2010)

Report structure shows:

Division, Total YTD count, Closing month, Q2 change

Div1, [count]where([division]=“div1”),
Div2 , [count]where([division]=“div2”),

now I need to display the counts for closing month and Q2 change (Q1-Q2) columns for 2010 using the date format mentioned above.

please let me know if you would need more information …I would appreciate any help.

Thanks,
B

baboo_ca (BOB member since 2010-06-22)

2

Hi

Can You provide more details.

Thanks,
Arun

aroonkaury (BOB member since 2007-06-08)

3

hi, and welcome to B :mrgreen: B

You should have the corresponding period objects in your univers (Quarter, month, etc) and bring them to your query

bernard timbal :fr: (BOB member since 2003-05-26)