Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Count

Hello Community   My data is as follows and i am expecting get the results as the last column (Lines Count) in bold letter basically i would like to display how many lines are there in a perticula...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

I have a join to another table, and one of the column from 2nd table is also displayed, in such cases i am getting a duplicate row for that order..

v-yuta-msft's avatar
v-yuta-msft
Community Support
7 years ago

Anonymous ,

 

Just remove Line and #Qty column in values field.

 

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Dear Support Team

     

    as i indicated in my original request, i am getting the count when i just display the order number

    but my requirement is to the count when all the fields are in the table

     

    thanks,

     

    • v-yuta-msft's avatar
      v-yuta-msft
      Community Support
      7 years ago

      Anonymous ,

       

      In query editor, click transform and then click remove duplicate rows.

       

      Community Support Team _ Jimmy Tao

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.