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.

    • 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

Like Follow
  • 8 mths agoLast active
  • 2Replies
  • 20Views
  • 2 Following