pivoting data with count

looks like i not understand how pivot works

I have follow records:

events,company=...,campaign=...,project=...,event_type=... value=1i

And want to execute SOLR like pivoting by company, campaign, project so output should be like:

company:1
 - count(event_type): 6
 - campaign: 2
    - count(event_type): 3
    - project: 5
      - count(event_type): 2
    - project: 6
      - count(event_type): 1
 - campaign: 4
    - count(event_type): 3
    - project: 7
      - count(event_type): 2
    - project: 8
      - count(event_type): 1

is it possible with flux pivot? seems it works in completely different way