matrix sum

[kasife]

Hi guys,

I have a matrix with product, hiring category and I use a simple sum measure https://ufile.io/mgis8210
From page filters I filtered all products that do not have sales in the PJ category in white

the result

This same result I would like to obtain in a matrix with the last 3 months, but we can see that the result of the CLT category is different. How could I measure with this filter to not consider products that have blank PJ sales?

[amitchandak]

@kasife ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

[kasife]

@amitchandak 

I would like to do the sum of the products when I have the PJ category.

For exemplo:

Producty	CLT Category	PJ Category
A	-	10	Sum
B	20	-	There is no PJ so disregard this product. The CLT category will not be included in the sum
C	12	10	sum
D	15	15	sum
E	10	10	sum
Total	37	35