10 Replies Latest reply on Oct 22, 2013 6:06 AM by Michael Boateng

    ATTR Function Aggregation returning No Values (Sheet Attached)

    Michael Boateng

      Hello All,

      I am trying to aggregate one of my measures (Impressions) by one of my Dimensions (SalesOrigin).  I was able to create a couple of calculated fields using the ATTR Function to get the values I wanted.  But upon dropping it into the report there were no values returned.  Below are the calculations I am trying to compute.

       

      LocalImps

      If ATTR([SalesOrigin]) = "Local"

          THEN Sum([Impressions]) END

       

      NationalImps

      If ATTR([SalesOrigin]) = "National"

          THEN Sum([Impressions]) END

       

      STR

      ([LocalImps]+[NationalImps])/Sum(Impressions)

       

      Might any of you have any insight as to why when I drop these calculated fields into my sheet I am not seeing any data?  Thanks in advance for all of your help..

       

      UPDATE:  Per @Matthew Luttonsuggestion I have uploaded a version using Sets.  Thanks.