Hi , I am facing issues for mapping 2 data sets in one single report. I have report level filters like Region, LegalEntityName, Product, Rates, Currency, Year, Month and Dynamic Hierarchy but when I add the 2nd dataset it gets mapped and filters only for Region, LegalEntityName, Product, Year(without any year selection), and Month individually but if we link(Info window) the 2nd dataset table to the main section object then only Region, LegalEntityName, Product filters works and the remaining filters fails i.e. Rates, Currency, Year, Month and Dynamic Hierarchy. Also, I have noticed that when I am moving to the 2nd dataset table the Region, LegalEntityName, Product filters apply correctly but the year filters gives some ambiguous value like 21185 for 2018 selection. Please find the attached screenshot for your reference. Thanks for your help
... View more