I have a cross table of data like below:
CrossTable(FiscalMonth, Data, 3)
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?
No AEA_EUROPE is just the name of the category field in another table. It has the same values as the Category field in the cross table.
The calendar has the following fields:
and then a bunch of flags.
I have the format of FiscalMonth as MMM and Year as YY so it matches with FiscalMonthYear which is MMM-YY but I'm not having much luck of putting the data together
Depending on how you are going to use the AEA_DATA, you could link the AEA_DATA to the ITEM table and then use the P() function in your calculations for the AEA_DATA.
AEA_DATA would look like this:
FiscalMonthYear as AEA_FiscalMonthYear,
Category as AEA_EUROPE,
In calculations for the AEA_DATA,