0

Max of Date

Hi All

 

I need to show Maximum of date in report.

Ex: if Date column has 

4/3/19

10/17/19

3/10/20

 output should be 3/10/20.

And there should be a Group by 

In because i need to have it by region number.

 

Thanks

Pavan Kumar

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Hi Paven,

    You can set the aggregation on the date field  to MAX if you put in the measures and then put add region number to the group by.  This should give you max date for each region number.

    Phil

    Like
Like Follow
  • 9 days agoLast active
  • 1Replies
  • 28Views
  • 2 Following