Pivot table calculated field Count(field) / sum(field)



If I have a table that looks like this:

row count sum
a 2
a f 2
a f 0
b 1
b f 1
b 1
c 5
c f 3
c f 2

How does one make a pivot like this:

Row Labels Count of count Sum of sum %
a 2 4 50.0%
b 1 3 33.3%
c 2 10 20.0%
Grand Total 5 17 29.4%

where % = count(count) / sum(sum)?

It seems as if count() is not really available in a calculated field???

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question