Get the aggregated data in expression

[rajat2392]

Hi everyone

I have two tables, one with 4 fields, those are a Unique Chasis no., Model, Year, Feature_opted.

Second table has 3 fields, those are Model, Feature, and Category. Category states as optional or standard. Standard means the vehicle will must have this feature and optional a customer may opt.

I want to show two tables, one which shows the opted features, and other that shows only the optional features for that model. See the picture below.

Data is attached. Please reply soon as possible.

Thanks

Rajat

[bbi_mba_76]

Hi,

could you have a look at the attached file?

[rajat2392 · Accepted solution]

Hi Michele

Thanks for the answer, but it is not exactly what I required.

What I require is the second table should show all the features that are optional, either opted or not by the customer. But all the optional feature should come.

So with reference to your answer, I have created this which gives me what I needed. Thanks for the helpful answer.

Rajat