pivotp does not allow simplest use case
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 ?
关闭于 2026-04-12 0 条评论