This content has been marked as final. Show 11 replies
I am struggling with something and would need help.
I have a table with shows PLAN and ACTUAL SALES for Financial Year 2014.(which starts from Sept 2013)
Now when I click on year it sums sales (i.e. 8) and sums plan (i.e. 43) .... but I want to find a way so that it sums plan only for the month where we have a sales numbers i.e. it should only sum plan = 2+3+4+3 ....
Not sure how to find out the month which have actual sales.
|Month '14||Plan($) ' 14||Actual Sales($) '14|
thanks in advance