|I have table like below:||(qvd)|
|I need report as below:|
You will have
Invyear invmonth inv_no inv_code as dimentions
inv_lc_amt match_lc_amtbe your expressions
only(inv_lc_amt) will be your first expression
sum(match_lc_amtbe) will be your second expression
Please when you have found your solution please mark as correct and the ones which were helpful please mark as helpful so that you can also help others with your question and so that other people don't respond endlessly while you have the response
Please suggest me for following dimension only
invyear,invmonth for the same expression.
It is working if I have invno, invcode; But please suggest only for INVYEAR,INVMONTH
Sorry not to mention before, I checked out when the result total is wrong. There are invoices where there is no matching MATCH_LC_AMT, in my context not yet collected.
Please advise. Thanks for all help.