Hi All,
I am trying to add my currant groupby formula to another filter an alphabetical gallery, when pressed to show only the clicked alphabet, please
LastN(
FirstN(
Sort(
AddColumns(
GroupBy(
AddColumns(
Filter(
'Check Management',
StartsWith(
'Business Name',
SearchText_22.Text
),
(Status.Value = ControlComboBox_11.Selected.Value)
// 'Date due' =drpDueCheckfront.SelectedDate
),
"Companyvalue",
'Business Name'
),
"Companyvalue",
"NewGroup"
),
"SumShippingFee",
Sum(
NewGroup,
amount
),
"TotalCOD",
Sum(
NewGroup,
amount
),
"Status",
First(
Sort(
NewGroup,
Status.Value,
Descending
)
).Status.Value,
"Email",
First(
Sort(
NewGroup,
Emails,
Descending
)
).Emails,
"ID",
First(
Sort(
NewGroup,
ID,
Descending
)
).ID,
"Comments",
First(
Sort(
NewGroup,
Note,
Descending
)
).note,
"Modified",
First(
Sort(
NewGroup,
Modified,
Descending
)
).Modified,
"CheckDuedate",
First(
Sort(
NewGroup,
'Date due',
Descending
).'Date due'
),
"OrderDatesFull",
First(
Sort(
NewGroup,
Created,
Descending
)
).Created,
"Pending Invoices",
CountRows(NewGroup),
"Check Number",
First(
Sort(
NewGroup,
'Check Number',
Descending
)
).'Check Number'
),
OrderDatesFull,
Descending
),
drpPaginationSize_5.Selected.Value * varPageNumber
),
If(
icoNextPage_3.DisplayMode = Disabled,
drpPaginationSize_5.Selected.Value - (drpPaginationSize_5.Selected.Value * varPageNumber - CountRows('Check Management')),
drpPaginationSize_5.Selected.Value
)
)
Thank you
