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.