Forum Discussion

Housden996's avatar
Housden996
Icon for Helper II rankHelper II
2 years ago

Filtering down by year when more than one relationship needs to be applied

HI all

 

I have a slight issue filtering down year between two tables in a rather complex report.

 

I have 3 tables shown bellow:

Currently the join between the budget and the working days file is on data such as Mon-Mon, Mon-Tue, Mon-Wed, e.t.c depending on the allocated budget, into the middle table which looks like this:

Which is then connected into the period file via the day of week.

 

Due to this not having any indication of year within the filter currently this pulls in the currant and previous years budget. 

 

Due to how the budgets are structured the ammend date is the start of the contract ie 01/01/2024 (UK format). What would the best way be to filter down by the bottom relationship whilst also filtering down by the year?

 

Basically I need the bottom relationships active as well as a year relationship active ass well to filter down the contract year as well.

 

 

2 Replies

  • Basically I need to use 2 slicers at once at the same time the Ammended Data as a year slicer and the Date as a normal date slicer.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Housden996 

    Can you provide some sample data and the output you want so that can provide more suggestion for you.

     

     

    Best Regards!

    Yolo Zhu