How to display the Measure value of the last months for qtr

building reports webintelligence
1

Hi,

I have a scenario,where in I have a Measure called Active ,which needs to displays the values of last month of each quarter.

Eg : Jan Feb Mar Apr May Jun Q1 Q2 Q3
100 200 300 400 500 600 300 600

Objects used are : Month name(Dim) , Quarter Name(Dim) and Active(Measure)

Would appreciate,if any one can help me out.

Thanks,
Hrishi

Hrishi_BO (BOB member since 2008-02-28)

2

Any solution for this?

bobjkb :india: (BOB member since 2004-03-19)

3

You can use a formula in place of quarter name to get the desired results:

First you can link a month number to each month and then use (you can hide the month number in your table)

The numeric variable [Month_number] will be something like

=if([Month]="Jan";1;if([Month]="Feb";2;............))
=Max([Month_Number]) In([Quarter Name])

Please try it and let me know if it works.

Prashant Purohit :india: (BOB member since 2009-02-18)