Hi all,
I want to automize the following (and do not succeed -which is why I am here):
Count the number of specific values (1=yes) in different colums, for specific subgroups in my data.
Fi: all persons with in column c: "1", count all "1's" in a specific colum.
I hoped I could easily get my frequencies in a pivot table, but as it are all zero's and one's... pivot table makes a kind of tree structure, with all zero's and one's....which make it difficult to read.
I could off course make a pivot table per variable/column; but maybe there is an easier way?
Thank you for your time & help.
I want to automize the following (and do not succeed -which is why I am here):
Count the number of specific values (1=yes) in different colums, for specific subgroups in my data.
Fi: all persons with in column c: "1", count all "1's" in a specific colum.
I hoped I could easily get my frequencies in a pivot table, but as it are all zero's and one's... pivot table makes a kind of tree structure, with all zero's and one's....which make it difficult to read.
I could off course make a pivot table per variable/column; but maybe there is an easier way?
Thank you for your time & help.