Struggling with Set Analysis

[#1]

Hello,

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. 😎 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
Sep	2	2
Oct	3	3
Nov	4	2
Dec	3	1
Jan	2
Feb	3
Mar	4
Apr	5
May	6
Jun	4
Jul	3
Aug	4
Total	43	8

thanks in advance

H

[#2]

Manish,

Can we somehow replace >0 by isnotnull or something?

As sales can be -ve

[MK_QSL]

Haven't tried but may be something like below...

=IF(AGGR(SUM([Sales Actual]),Month)>0 and Not ISNULL(AGGR(SUM([Sales Actual]),Month)),Month)