How to Select the Current Fiscal Year
I have a data module that lands data in a monthly basis.
I then created a module that has Q1 to Q4 line items - the intention is to get the data from Mar 23 for Q1, Jun 23 for Q2, etc.
So I then created a module with the below line items and with the year as my time dimension and put a formula in each of them so the Mmm YY is automatic in each of them:
In my target module, formula for Q1 line item is below:
DataModule.LineItem[LOOKUP: System Module.'1st Qtr Month Lookup']
I would like to specifically get the amount from my data module from Mar 23 and place it in Q1 target module, but the amount does not show up. If I removed the Time dimension, and manually put in Mar 23 for 1st Qtr Month Lookup, Jun 23 for 2nd Qtr Month Lookup, etc. above, then I will get the amount.
Thanks a lot…