3 Replies Latest reply: Oct 20, 2016 2:05 AM by Jim Chan RSS

    Problem to display correct data in pivot table.

    Jim Chan

      Hi guys,

       

      I have having a problem to show what client wants on the pivot table.

       

      the data is made up from 2 tables. using concatenate.

       

      table1

      record_id

      business

      year

      version

       

      concatenate(table1)

      table2

      record_id

      business

      year

      version

      details from table2

       

      So. after loaded, i managed to get the data. like ID 4611, but it will also provide me another row of empty data in details_from_table2 field. for this line, I just want to show field with data only.

       

      But, client also wants to see ID that has no data in details from table2.  for example ID 4610. I want to show this line too.

       

      i have tried checking suppress/omit null value. but it will show me IDs that has data in details_from_table2.

      i have also using expression like count( distinct record_id), thought this would help me to distinct the record_id.

       

      What should i do in the expression?

      screenshot1.jpg

       

      rgds

       

      Jim