Skip to main content

Hello,

Can someone assist me on this request?

How do I only show the Max(Date) and its corresponding dimension value in the report when all other dimensions are all in the report view.

 

For example, from this table, I only need to show the category for a user who has the last date.

  1. XYZ - Car -11/03/2022
  2. ABC - Car -04/01/2022

Get the Corresponding Dimension value for the Max(Date)Thanks in advance.

10 件の回答
  1. 2022年9月21日 21:55

    Yes you can:

    {FIXED User, Category:Max(If Quantity >=1 THEN Date end)}=Date

0/9000