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.