How to compare Same Quarters of Differennt years?

[300sss300]

I have 03 years 2013, 2015 & 2015

If I select each year separate it gives variation for 04 quarters for that year only using "Sum - Above Sum"

But when I select Q1 for all years it is not working.

I want to see variation for Ist quarter only with all years selected.

Any help much appreciated.

Best Regards,

Khayam

sunindia‌ brunobertels‌

[sunny_talwar]

Would you be able to share your script you are using? Difficult to comment without seeing

[300sss300]

LOAD *,

  Dual(Year & '-' & Quarter, (Year & Num(PurgeChar(Quarter, 'Q'), '00')) * 1) as YearQuarter;

LOAD Year,

     Quarter,

     Sales,

     [Other Income],

     [Total Revenue]

FROM

(biff, embedded labels, table is Main$);

LinkTable:

LOAD YearQuarter as ReportingYearQuarter,

  YearQuarter,

  'CYQ' as Flag

Resident Main;

Concatenate (LinkTable)

LOAD YearQuarter as ReportingYearQuarter,

  YearQuarter - 100 as YearQuarter,

  'PYQ' as Flag

Resident Main;

[300sss300]

Where to use these 2 expressions

whether in script area or in chart as expression ???

[sunny_talwar]

Would you also be able to share the logfile to check out the error?

[300sss300]

Lets say I have an excel file which contains worksheet having above data named "Main".

Now what will be my script???

Regards,

Khayam

[sunny_talwar]

Your tab name on the Excel says Main? What does this has to with what we are discussing here my friend. Would you not be able to share the logfile? I can quickly glance over your logfile and see what might need to change.

[renuka_sasikumar]

If I select Year it's give only one Quarter Data instead it should give previous Year Data as well.

For eg. When I select 2015 it's should show 2014 Max Quarter also