In a pivot table, I only want to display the records where for each item in the field “Besteknummer” there are the items “Goedkeuring bestek” and “Gunning van de opdracht” in the field “Etappe tekst”.
A chart like a pivot table is used to aggregate records grouped by dimensions. So if you want to display records, you'll need to add a dimension that is unique on the lowest level you want to see, i.e. record level. So you probably need to add something like a RecId to your data model and your chart dimensions. Then you can filter your records using conditionals or adding a set expressionset in the aggregation function.
