Attached show the distinct date of GRN with expression: =Count({<[Trading Year]=,[Trading Month]=,[Trading Week]=,[Date]=>}distinct([Weekly GRN Date]))
Its current result shows Count of Date = 3
I would like to group it according to trading week as well so the count result =1. I am thinking to use aggr but show me the same result =3 .
I'm not sure I understand your request, but if you're looking for a distinct count of trading weeks, rather than dates, why not count that field rather than the date field?