Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi guys,
i have one issue in using set analysis -
=Sum({$<Year = >} aggr(DISTINCT(Value),%Key))
i want all Year, so want to exclude any year selection and aggr distinct function too..
in dimension i am using month and FY.
% Key is combination of Territory and Dates.
this code is not working for me...please if anyone can solve it....
please check attachment for more details.
Try
Sum({$<Territory={"*"}-{'Global'},Year = >} aggr(DISTINCT(Sum({$<Year>}Value)),%Key))
and
Sum({$<Year = >} aggr(DISTINCT(Sum({$<Year = >}Value)),%Key))
in AGGR you need to use an aggregation function like Sum or Only or Count etc...
and in this case you can use set analysis before agregation
PFA
Try
Sum({$<Territory={"*"}-{'Global'},Year = >} aggr(DISTINCT(Sum({$<Year>}Value)),%Key))
and
Sum({$<Year = >} aggr(DISTINCT(Sum({$<Year = >}Value)),%Key))
in AGGR you need to use an aggregation function like Sum or Only or Count etc...
and in this case you can use set analysis before agregation
PFA