On a case I have two choice properties, ‘District’ and ‘Legacy District’.
There are a number of identical values within both properties, however ‘Legacy District’ also contains some unique values.
A case would only ever have a value saved within one of the above fields - never both.
The two properties are included within a composite which is [District][Legacy District].
The issue i have is when using the composite within a pivot table.
11x Cases where ‘District’ is set to ‘Barrow’ and ‘Legacy District’ is empty
1x Case where ‘District’ is empty and ‘Legacy District’ is set to ‘Barrow’
I would expect to see 12x Cases on one row
Is there a way this can be achieved?