Facing Count Problem in Pivot

Mon, 30 Aug 2010 03:52:41 GMT

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.

topic Facing Count Problem in Pivot in QlikView

Facing Count Problem in Pivot