4 Replies Latest reply on Mar 4, 2012 11:29 AM by bruce lomasky

    Format Row Name with Index in Name

    bruce lomasky

      I have a table with customer names on the rows shelf and multiple measures on the columns.  I am sorting by total sales and instead of having the INDEX() as one of the columns, I would like it to look like this:

      (1) Fred

      (2) John

      .......

       

      I created a calc. field called INDEX, then tried to create a new calc. field that I would use for the rows as:

       

      "(" + STR([Index]) + ") " + [name]

       

      But I get can not mix Aggr with Non Aggr functions. 

       

      Any suggestions?

       

      Thanks

       

      Bruce Lomasky