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?
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?