Thank you @GayathriAnand-Oracle I managed to get this to work, but I had to change it from a pivot to a table. Not all of my reports will work this way though. Is there a way to achieve this in a pivot table also?

@Gianni Ceresa Thanks for your feedback. I tried FILTER(…USING…) and it works well. FILTER("Ledger Report View"."Posted Trans Amount" USING "Ledger Report View"."Fiscal Year" = 2024) However, I can't figure out the syntax to add another filter to the same column. I tried putting AND after the 2024, and I tried using the…

@Kathy-Oracle Thanks for the suggestion. I had already read that, but there's only a couple paragraphs about complex joins and how they work. There is no information at all about how to go about it, and no examples. @Gianni Ceresa Now I understand what you mean by creating 3 LTS and it makes a lot of sense. Thank you for…

@Gianni Ceresa You were right. I deleted the join and then tried it and did not get the error. I haven't tested it yet though. If it runs too slow, how would I create separate aliases for the 3 different join conditions and then merge them back? Also thank you for your response!