Unable to get output from first version/last version filter

I want to get the sum of qty group by customername order by orderid

Iam getting #error

this is the formula Iam attaching


2replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Ramaraju Hema Kavitha -- it is hard to help you with this little amount of information.  If you simply want to get a SUM of a Quantity field grouped by customer name, I would recommend that you create an aggregate table.  The table will let you put "new_schema.orders.CustomerName" in the Group By shelf and you can put "new_schema.orders.Qty" in the metrics shelf as a SUM.  There are sorting and ordering options from there.

    Reply Like
    • Dan Brock  Yes i will attach more info about the issue Iam facing.

      For the above, if I use group by dimension, column  with sum in the measure I will get all the records

      but Iam trying to get only the earliest record/latest record of each.

      So, Iam going for first version/last version

      Reply Like
Like Follow
  • 4 days agoLast active
  • 2Replies
  • 9Views
  • 2 Following


Welcome to Incorta's user community! Whether you are already an Incorta customer, or interested in becoming one, this is your place to come together and discuss the software, register for webinars, learn about events, learn about new product releases and get support from the community. 

Looking for Product Documentation?