I am seeking assistance with an Income Statement report I am currently working on.
This report involves a comparison between actual and budget figures, complete with a variance column. The calculations for both actual and budget numbers are based on the Main Account category, as evidenced in the attached screenshot. Additionally, the report offers filtering options, specifically for date, year, and legal entity.
However, I have encountered an issue pertaining to the Date filtering options. Currently, when I select a Date and year filter (as depicted in the provided screenshot), the changes are only reflected in the Actual figures. This discrepancy arises because these filters draw from the actual date and year values found in the actual table.
On the other hand, the Budget Date and Budget Year columns in the Budget table are utilized for their respective budget figures within the specified year. Consequently, I am in need of assistance regarding the implementation of date and year filters. I aim for these filters, upon selection, to appropriately display the actual and budget columns in their respective designated columns. Your guidance in resolving this matter would be greatly appreciated.
Note : I have had an issue with a LE filter also intially which I resolved by using Slicer table as shown in the screen show. Date filter may need a calendar slicer to pick up dates and year from both tables possibly.
