Forum Discussion
matrix sum
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?
2 Replies
kasife ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.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
