Hi All,
I am facing Problem with the Total in Pivot Table . So, I have used aggr function to overcome this . The problem is I have to select the dimensions as cyclic . The following is the expression I have used ..
sum(Aggr(Count( distinct FACT_ID),Fact_Year,Fact_Org,Fact_City))
SO my thought is to replace the dimensions Fact_Org,Fact_City dynamically when I select a selection in the cyclic group.
for that I have created a variable curr and passed the value as getcurrentfield(GroupName). Group name is my cyclic group .
Now my expression is like below .
sum(Aggr(Count( distinct FACT_ID),Fact_Year,$(curr)))
but this is not working . I request your kind help ..........................
Thanks in Advance ........
Regards,
Chakravarthy.