Year to date break up table

[Mrajani]

Hello Team,
I need a help on urgent basis. I want break up details in a table/matrix visual fro year to date total.

Fiscal year = July to June

For example, If I select Nov 2022, then table should have details from July 2022 to Nov 2022. If I select Jan 2023 then table should have details from July 2022 to Jan 2023. Now In the sam visual I also want value from particular column for selected month for all the row in break up table.

Query 1 - I want exactly the same table that has in the below screen shot. I have Selected "Nov 2022" month and break up table is from July 2022 to Nov 2022. July has no data so it is not visible.

Query 2 - But Lots Active value should be for selected month Nov 2022 for all the Buildings and not the running total or not the value for particular month for the building.

Query 3 - Annual fee is calculated as "Fee * Lots Active for selected month". But the total is incorrect as I have used multiple fields in Table. How to get the correct total?

How can I do this? Kindly help me to resolve this as soon as possible.

Required Information:

1. Slicer is coming from Calendar table.

2. Building table and calendar table has 1 to many single directional relationship.

3. Fee is coming from Fee table which has many to many both directional relationship with Building table with Buidling Number.