2 Replies Latest reply on Jun 6, 2018 2:03 PM by Jim Dehner

    Issues with totals using a measure vs dimension

    Ashan Bogollagama

      HI,

       

      I have a table as shown below that displays everything as should be. However when I try to total the (Actual Amount) column it would still show "15"

       

      I changed (Actual Amount) field from a dimension to a measure and now it Sums up the (Actual Amount) values for each (Customer) and displays the sum in each row as seen below. And the new total SUMs the SUMs of the Actual Amount.  

       

       

      Any idea what is happening? And is it possible to add up dimensional field?

       

      Thanks,