1 Reply Latest reply: Dec 17, 2012 6:06 PM by Logesh Jayaraman RSS

    Date Question

      Why is it that when I remove a date dimension from my table, the expression shows a different number. Is my Data Model not working correctly? I dont' want to have the date in the table, as I just want to sum by Region.

       

      Thanks,

       

      Alex

       

      Edit Text: So it has been modified some, now when I remove the two ID's Billtype and Project type. My numbers change from the correct values. What do I need to do to not make the values change when I remove those IDs?

       

      Incorrect total without the BillType and PaProjectType

      I'vprovided the qv and qvs.ScreenShot275.bmp 

       

      Correct total with both billtype and paprojecttype.

      ScreenShot274.bmp