5 Replies Latest reply: May 28, 2012 5:03 AM by Jason Michaelides RSS

    Aggr formula

      Dear All,

       

      Plz refer to attachment.

      I want to find out query % month on month.

      e.g. In this example, in 1st column, I want to find Count of "Duplicate" type query. This I got.

      In 2nd column, I want total no. of "Duplicate" type query. In 2nd column, against each month, in front of "Duplicate", there should be same no. as 7 (sum of "Duplicate" queries across all months).

      I tried with Count and Aggr function as

       

      Textcount(Aggr(Textcount(QueryType),QueryType))

       

      What is wrong here?

       

      Thanks.