Display records

[#1]

Hello

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”.

How can I achieve that ?

Thanks in advance
Marc

[swuehl]

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.

[#3]

Hi

Thanks a lot for the information

Marc