T
todd.heiks
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???
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???