Need to do sum based on group by value

[Anonymous]

Hi Team,

I have data like below, i wanted do sum(sales) where i dont want to include sales to result values when sum(proft,on product)=0.

In the below Sum(sales)=85822728

but when sum(profit)=0 on product-wise, then want to exclude those sales.

so according to condition my sales needs to be : 50396631. (Note Here Prod-B, Prod-D, Prod-F wise sum(profit)=0, so i am excluding those products related Sales)

Note: i dont want to see result with the fields( ID, Category, Sales, Profit) filled in resulted pivot table

(Consider "Sheet-to-be-considered" for pivot creation)

Example source is showed below:

Id	Product	Category	Sales	Profit
14	Prod-A	X	1608310	6756
435	Prod-B	Y	4033646	-2000
815	Prod-C	Y	9659959	7445
198	Prod-A	Z	5283048	876875
786	Prod-A	X	7678475	764764
540	Prod-C	Y	6670675	6767
50	Prod-B	Z	8619825	43000
796	Prod-C	X	416943	877
60	Prod-C	X	2474560	8756
858	Prod-A	X	6679131	875
729	Prod-C	Y	3108168	849
918	Prod-B	Z	1167124	-3544
22	Prod-B	X	4478197	-37456
405	Prod-A	Y	6817362	6738
187	Prod-D	Y	6288128	-1000
861	Prod-F	Z	9029374	350
488	Prod-D	Y	6913681	-250
420	Prod-F	A	5303154	-350
71	Prod-D	Y	881919	1250

Result would be like below in pivot attached copy.

[sunny_talwar · Accepted solution]

May be try this:

Sum({<Product = {"=Sum(Profit) <> 0"}>}Sales)