Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone, I have a dimension in which I show only the components that are part of the Material A:
=Aggr(Distinct Only({<Material = {'A'}>} Component), Component).
This works perfectly if I dont filter any other field.
However, when I filter another field "[Material Group]" for example, my aggr dimension returns only null values.
I've already tried these two approaches but they dont work:
=Aggr(Distinct Only(1{<Material = {'A'}>} Component), Component).
=Aggr(Distinct Only({<[Material Group]=,Material = {'A'}>} Component), Component).
Thank you
Try this
Aggr({1}Distinct Only({1<Material = {'A'}>} Component), Component).
Thanks for your reply, it didn't work. It also returns null values.
Hi,
Try these expressions
Aggr(Distinct Only(Total{<Material = {'A'}>} Component), Component)
or
Maxstring({<[Material Group]=>} Aggr(Distinct Only({<[Material Group]=,Material = {'A'}>} Component), Component))