i have the following data set:
GROUP,NAME
G1,N1
G2,N1
G3,N2
G4,N2
G5,N1
G5,N2
G5,N3
can only create a pivot like: qsv pivotp --grand-total -i GROUP -a len -v NAME 'NAME' test.csv that looks like this:
GROUP N1 N2 N3
G1 1 0 0
G2 1 0 0
G3 0 1 0
G4 0 1 0
G5 1 1 1
Grand Total 3 3 1
but there is no way to make it look like:
GROUP count
G1 1
G2 1
G3 1
G4 1
G5 3
Grand Total 7
what am i missing ?
i have the following data set:
can only create a pivot like:
qsv pivotp --grand-total -i GROUP -a len -v NAME 'NAME' test.csvthat looks like this:but there is no way to make it look like:
what am i missing ?