0 Replies Latest reply on Nov 6, 2012 7:22 AM by Basheer Al-Khatib

    SAP BW: measure aggregation by server, total disappears when filter applied

    Basheer Al-Khatib

      Hello,

       

      I am using Tableau 7.0.9 to connect to SAP BW as part of a trial. All is good so far except:

       

      I have a measure whose Field Properties < Totals is set to "Server" (I need the server defined aggregation which is a distinct count). The total for the Column displays correctly. However, when I filter by any dimension (even if I don't actually filter, and I just place a dimension on the filters shelf), the total disappears.

       

      Any idea why this is happening?

       

      Thanks,

       

      Basheer