3 Replies Latest reply on Jul 31, 2018 10:44 PM by kumar bharat

    SAP BW Calculated Member

    Bridgette Burlingame

      I am trying to create calculated members in Tableau from an SAP BW data source.

       

      I have a date field with a format of MM.YYYY. I need to be able to aggregate Sales to the YYYY level, but cannot do so with this format. I am trying to create a calculated member to get these results in one way or another, but cannot seem to get any formula to work.

       

      This is what the field values/description looks like. Is anyone able to help figure out what the MDX should be?