topic Re: Percentage in pivot table in App Development

Percentage in pivot table

leobrand — Mon, 02 Jul 2018 02:19:55 GMT

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])

Re: Percentage in pivot table

lironbaram — Mon, 02 Jul 2018 06:01:54 GMT

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])

Re: Percentage in pivot table

big_dreams — Mon, 02 Jul 2018 06:09:51 GMT

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

Regards,