2 Replies Latest reply: Mar 23, 2014 4:40 AM by Marc Van Rie RSS

    Display records

      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

        • Re: Display records
          Stefan Wühl

          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.