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?




      Bruce Lomasky