try using COUNT instead of COUNTD. COUNTD only counts the distinct elements,
Thanks for your help. I believe that it is the right way to get what I want but it does not work for me!
I think I am facing a problem while creating the calculated field of %scrapped part:
I created a calculated field % ratio= SUM (%parts)/ SUM(%scrapped parts) , it is shown as AGG (SUM(%parts)/ SUM(%scrapped parts)) so when I create the test (calculation1) I can not use to compare (>0.5 ..) so I retype it. When I drag then the calculation 1 to my table , it is shown as AGG(calculation1)!!
I think I have problem in the aggregation! could you help me with that?
Can you post screenshots of your calculations please?
Definitely sounds like an aggregation issue
Attached is a screenshot of the workbook. Just to let you know when I remove plant codes (STORES) from the rows, it shows me for the country (china for example) the total number of stores in just one column ( >0.5 or <0.3 or BEtween). It is like the all the values are added and if the total value is >0.5 for example, then the column >0.5 will contain e the total number of stores(plant codes)!!
Thanks for ur help!
I forgot to say that I did not use the CNT instead of CNTD because when I use it , it shows me the whole number of all the rows that contains the plant codes for a region . (for one plant code/stores, there are thousands of products stores) so when I use CNT it gives me the total number of products. that is why I use CNDT bcz I wnat just number of plants/stores.