Author Topic: Column Format to be considered for groupping  (Read 1144 times)

j.jose

  • Newbie
  • *
  • Posts: 8
    • View Profile
Column Format to be considered for groupping
« on: August 30, 2021, 06:56:00 pm »
Hello,

Is it possible to consider the format of the column while groupping.

For example: I have a date column for which the format is set as 'yy'.
If this date column is selected for grouping, then the format of 'yy' is not considered and instead the original values of the column are considered.

Is it possible to include a functionality so that the groupping is done based on the user-entered format.

Thanks in advance.

Best regards,
Jiny

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 5733
    • View Profile
Re: Column Format to be considered for groupping
« Reply #1 on: September 01, 2021, 10:15:14 am »
It's simple.

Store the original values in a separate hidden column and use grid formula feature or getters / setters to deduce the values in column used for grouping