Hi,
I am using the first table as a filter to display data in the second table. When I click on the "Previous Month Activity Amount" in the first table, I expect the second table to show data for the previous month. The "Previous Month Activity Amount" is calculated using the AGO function as follows:
AGO(@calculation("NetAmount_3"), "Financials - GL Detail Transactions"."Time"."Fiscal Calendar"."Fiscal Period", 1)
I am not getting the expected results as shown in the screenshot. The current period is November 2024, so when I select "Previous Month Activity Amount," the table below should filter to show data for October 2024 instead, but that is not happening.
Can you please help with this.
