Joining Cross Table with data and calendar

[khaycock]

I have a cross table of data like below:

CrossTable(FiscalMonth, Data, 3)

LOAD Key,

     Category,

     Year,

     Jan,

     Feb,

     Mar,

     Apr,

     May,

     Jun,

     Jul,

     Aug,

     Sep,

     Oct,

     Nov,

     Dec

That I need to link to both the data (Category AS AEA_EUROPE) and also need to link the month and year to the calendar (either FiscalMonth and FiscalYear or FiscalMonthYear) but when I connect the both, I get loops. What is the best way to get them all linked without getting these loops?

Thanks

[khaycock]

Yey that worked! Thank you

[khaycock]

Actually Jerry,

Instead of using:

AEA_DATA:

FiscalMonthYear as AEA_FiscalMonthYear,

Key,

Category as AEA_EUROPE,

AEAData

I used this:

AEA_DATA:

Load

Key,

Category AS AEA_EUROPE,

Month&'-'&Year AS AEA_FiscalMonthYear,

AEAData

Because of my Month and Year fields...

And it worked initially when only a specific month was selected. But when I want to view all of the months together as a years view, the data returns the same amount of each month, rather than calculating different amount like its meant to.

Here is the results I am getting for the year view of Jan and Feb:

When actually it should be showing these results:

I think its a subtotal of the whole year but displaying it on every month? Not sure why some have 0 though. Any ideas?