Forum Discussion
Group documents in a matrix table
hello everyone once again
I'm trying to build a table of pending payment documents, grouped by overdue (Total Receivable Overdue) and not overdue (Total Receivable Expiring).
I need your help to create a way to group these documents by Total Receivable Overdue and Total Receivable Expiring
REPORT EXAMPLE
example table:
I created a measure for the group
Group =
Var Group = [Overdue?]
return
IF( Group ="Yes", "Total Receivable Overdue", "Total Receivable Expiring")
The due days of the documents are calculated by a maximum date that I indicate in a filter
Days Expired =
Var difference = DATEDIFF(max(Client[due date]), [Date Max], DAY)
return
difference
The max date formula
2 Replies
ngomes , Grouping means do you want to use that in the group by/row/column/axis. If yes you need dynamic segmentation
refer this example - is hows how deal with such measures
Customer Retention with Dynamic Segmentation, New/Lost/Retain Customer Count: https://www.youtube.com/watch?v=W4EF1f_k6iY
Good afternoon
I want to group by row, in this example I will have only two groups
1- Total Overdue Receivable
2- Total Receivable to Expirethanks
