LinkedIn
Twitter
I have created a VC for monthly sum with the formula
SUM(
SELECT(
Daily trip[Amount],
AND(
([Customer] = [_THISROW].[Customer]),
([Month] = [_THISROW].[Month])
)
)
)
But the issue sum is correct but while creating a UX tab with customer “name and sum”, it’s showing duplicate in the customer list.
For the below, I want all in a single line
