Hi,
I have multiple fields i need to report on, all with their own dates:
Application Amount Application Date
Approved Amount Approved Date
Deposit Amount Deposit Date
I have Unpivoted these and have a col for Date (All), showing the unpivtored dates and the following attributes: Application, Approved and Deposit date.
I have table which is interacting with the Date (ALL) slicer
The issue im having is that i want the table toshows all 3 amounts - which I have.
But I need:
Application amount to show only when the application date is within the slicer period
Approved amount ot show only when the approved date is within the slicer period
Deposit amoutn to show only when the deposite date is withn the slicer period
if I apply an attribute it will show the correct figure but only for whichever category (applied, approved or deposited) and if i leave the attrubute itll include all data across all dates as opposed to filtering each.
sample data:
| ID | Application date | Application amount | approved date | approved amount | deposit date | deposit amount |
| 67827 | 15/09/2023 | 12,000 | 20/09/2023 | 12,000 | 10/10/2023 | 12,000 |
| 4356 | 03/10/2023 | 50,000 | 11/10/2023 | 20,000 | 18/10/2023 | 20,000 |
| 85907 | 12/10/2023 | 100,000 | 20/10/2023 | 100,000 | 01/11/2023 | 100,000 |
| 47327 | 18/10/2023 | 150,000 | | | | |
| 578 | 20/10/2023 | 75,000 | 23/10/2023 | 50,000 | 02/11/2023 | 50,000 |
| 9746 | 21/10/2023 | 15,000 | 21/10/2023 | 15,000 | | |
| 36628 | 30/10/2023 | 55,000 | 01/11/2023 | 40,000 | 02/11/2023 | 40,000 |
what I want it to show:
DATE slicer: Last Calendar Month
| Apps | Apps (£) | Approved | Approved (£) | Deposited | Deposited (£) |
| 6 | 445,000 | 4 | 185,000 | 2 | 32,000 |
what it currently shows with date slicer applied (only seems to be interacting with app date:
| Apps | Apps (£) | Approved | Approved (£) | Deposited | Deposited (£) |
| 6 | 445,000 | 5 | 225,000 | 4 | 190,000 |
