2 Replies Latest reply on Sep 2, 2016 11:07 AM by Austen Robinson

    Totaling a measure without using the default sub totals in the worksheet

    Austen Robinson

      I do not want subtotals turned on in my worksheet but I do need to total a measure depending on what is in a dimension.  So I need to total each individual state using a calculated field but am having trouble with the syntax. 

       

      I tried some version of

       

      if([State]) == "VT" then sum([Sales]) END

       

      but that gave me and error saying I was trying to use a string and an integer in a calculation.

       

      Any help is appreciated.