Could you help me understand how I can Implement this logic, please?
I have 2 tables (Summary and Source table). In the summary table, I display the Sum() of the Price column.
I added the filter for column date in the source table.
How can I update data in the table Summary according to the interactive filter by date in the source table?
Because when I filter data in the source table, in summary, the table displays the sum of all data in the source table.
Expected result - sum in the summary table by filtered data in the source table.
Thank you!
Maybe this could work for the formula in your field Total (in your Summary table) :
[Source Table].Filter(
CurrentValue.Item = thisRow.Name
AND
CurrentValue.Date.matches(TheNameOfYourInteractiveFilterHere)
).Price.Sum()
What this does is :
Like you already did : We’re looking for rows from your table [Source Table] where CurrentValue.Item = thisRow.Name
→ which, behind the scene returns a first list of rows
AND
From that “hidden” first list of rows, we’re now asking Filter() to only keep the rows where CurrentValue.DateMatches() the value in your canvas control/interactive filter.
Both conditions here needs to be True for Filter() to do its job and keep a row in the final list of rows it will return .
Once we have that final list of rows, all that’s left is to Sum() the corresponding prices.
Here’s a quick sample to illustrate !
Don’t hesitate if you have questions or if something’s not clear .
But in the meantime, I hope this helps
@Andrew_Golovchenko wanted to be able to filter his Source table by Date using the interactive filter and see the result of the filter also reflected in the Total field in his [Summary Table] as said here :
I’ve added a small note at the top of my sample though , trying to clarify a little the situation here .
,
.
.
!
!