To get last 8 years quarters

[#1]

Hi All,

I have 8 years of data, if i click on current year Quarter 1 data then it should display last 8 years Quarter 1 data in a table.

if i click on current year Quarter 2 data then it should display last 8 years Quarter 2 data in a table...........

I tried it using set analysis but i'm unable to find the solution for this, Could you please give me some idea on this

Thanks,

VV

[whiteline]

Hi.

Add a field to your calendar that corresponds to Quarter # regardless of the year.

[ashfaq_haseeb]

Hi,

Alongside what whiteline suggest.

I would like you to create a composite key out of year and quarter even as shown below.

Year&Quarter as YearQuater

Select in field quarter let say you have selected quarter1(Q1)

and use this field fir displaying eight year result with proper breakups.

Regards

ASHFAQ

[dharmarasu]

Hi reddy,

       u get it by using set expression but one more thing u want to add is Conditional show.

       in expression Tab, enable conditional dialog box and write

          if(quarter='Quarter 1')

               and then in expression for an example

        =sum({<Year=,quarter={Quarter1}>}sales).

like wise u want to add  expressions for Quarter2, Quarter3, Quarter4 .

hope this helps

Regards,

Dharma

[jagan]

Hi,

Try like this

=Sum({<YearDimensionName=, MonthDimensionName=, DateDimensionName= >} MeasureName)

YearDimensionName, MonthDimensionName and DateDimensionName with your actual Year, Month and Date fields.

{<YearDimensionName=, MonthDimensionName=, DateDimensionName= >}  this excludes the selection of Year, Month and Date dimensions.

Hope this helps you.

Regards,

Jagan.

[#6 · Accepted solution]

Using SET analysis with ONLY function could be the alternative idea.

See the attached file.

I hope this will help you.