Sundry tips - Responses to Community Questions

Simplest way to group items individually from a multi-select list


tabPrice List
0
Service
Price
1
Car Wash
15
2
Tyre Replacement
50
3
Clean Interior
20
4
Check Drivers Licence
5
5
Phone for Follow up
10
6
Top up Fuel
70
There are no rows in this table
Scenarios 1a and 1b are the same table, but different ways of looking at the data.
Scenario 2 looks similar to your select list, but I used a Lookup, because then you can just add the price column from the Price List.
For both, finish it off by enabling Summary- Values for the price column.
tab Scenario V1a
1
Search
Scenario
Service
Price
Car service
4
Car Wash
15
Tyre Replacement
50
Clean Interior
20
Top up Fuel
70
155
Sum
Auto Sales
4
Car Wash
15
Tyre Replacement
50
Clean Interior
20
Top up Fuel
70
155
Sum
Test Drives
5
Car Wash
15
Clean Interior
20
Check Drivers Licence
5
Phone for Follow up
10
Top up Fuel
70
120
Sum
430
Sum


Scenario:
Test Drives
vw Scenario V1b
1
Search
Scenario
Service
Price
Test Drives
5
Car Wash
15
Clean Interior
20
Check Drivers Licence
5
Phone for Follow up
10
Top up Fuel
70
120
Sum
120
Sum
Scenario 2a - Detail view
Search
Car Service
Auto Sales
Test Drives
Car Service
Service
Car Wash
Tyre Replacement
Clean Interior
Top up Fuel
Price
15502070
Price - Sum
155
Column 3


Scenario 2b
Search
Car Service
Car Wash
Tyre Replacement
Clean Interior
Top up Fuel
15502070
155
Auto Sales
Car Wash
Tyre Replacement
Clean Interior
Top up Fuel
15502070
155
Test Drives
Car Wash
Clean Interior
Check Drivers Licence
Phone for Follow up
Top up Fuel
152051070
120
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.