1 Reply Latest reply: Jan 22, 2018 5:44 PM by Stefan Wühl RSS

    Count of Accounts which are invoiced mutiple times

    Snigdha burugupalli

      I have Dim_Account  where i get Account number  and Fact_Invoice table where we get invoiced Amount

       

      My requirement is to show a graph   like Revenue vs Monthyear   and Number Accounts Vs MonthYear.

       

      if i include invoice_Amount my Account number count are  not matching and givving huge number.

      If i remove Invoice_Amt from query and count on account_nbr i get right number of accounts,

       

      Please suggest me how to handle this as i need both invoice_Amt and Account_Nbr Counts.

       

       

      Thanks

      Snigdha