I am struggling to find a solution how to create a drop-down list where only certain elements are visible based on a filter. It is hard to explain so I created a dummy where you can see.
My goal is to have a drop-down list in the last table called “Planned expenses” but only with the expenses connected to Activity #1 not all. Somehow I am unable to create a working filter.
Budget
Activity #
Sum
Activity #
Sum
1
Activity 1
30
2
Activity 2
180
3
Activity 3
0
There are no rows in this table
Detailed plan
Activity #
Sub-categories
Amount
Activity #
Sub-categories
Amount
Activity 1
2
A1-Travel
€10.00
A1-Accommodation
€20.00
Activity 2
4
A2-Travel
€30.00
A2-Accommodation
€40.00
A2-Trainer
€50.00
A2-Materials
€60.00
Mobility plan_
Activity #
Amount 1
Amount 2
Activity #
Amount 1
Amount 2
1
Activity 1
$100.00
$200.00
2
Activity 2
$300.00
$400.00
3
Activity 3
$500.00
$600.00
There are no rows in this table
Planned expenses
Activity #
Sub-categories
christiaan
Column 4
Activity #
Sub-categories
christiaan
Column 4
1
Activity 1
A1-Travel
A1-Travel
Activity 1
2
Activity 2
A2-Accommodation
A2-Accommodation
Activity 2
3
Activity 3
Activity 3
4
There are no rows in this table
Want to print your doc? This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
