Percentage in pivot table

[leobrand]

I have a table with a few hundred rows of data and a field named “Dinosaur Type” that contains the contents Saurischia or Ornithischia only. 

I created a pivot table with Saurischia or Ornithischia in the row and I want an expression that will show me what percent of the table is Saurischia and what percent of the table is Ornithischia.

I tried the expression below but it is not working.  Can you help?

Count(If(Match([Dinosaur Type]), ‘Saurischia’, ‘Ornithischia’),1,0)/Count(Total[Dinosaur Type])

[lironbaram · Accepted solution]

hi

assuming the [Dinosaur Type] is a field in the data that connected to the data

this function should work

count ([Dinosaur Type])/count(total [Dinosaur Type])

if you want the percentage in any column to be 100%

you'll need something like

count ([Dinosaur Type])/count(total <attribute field >[Dinosaur Type])

[big_dreams]

or

count ([Dinosaur Type])/count({1} [Dinosaur Type])

Regards,