Pivot table measure

[leobrand]

Here is a sample of my data

Dinosaur Type	Dinosaur Name	Century Named
Saurischia	Tyrannosaurus Rex	1900
Saurischia	Allosaurus	1800
Ornithischia	Triceratops	1800
Ornithischia	Tyrannosauridae	1800
Ornithischia	Hadrosauridae	1800

I am trying to turn it into a pivot table like this

Dinosaur Type	1800	1900
Ornithischia	75%	0%
Saurischia	25%	100%

How do can I modify this expression as the measure in the pivot table to do that?

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

[Neymar_Jr · Accepted solution]

Hi,

Please try this -

count([Dinosaur Type])/aggr(nodistinct count([Dinosaur Type]),[Century Named])

Thanks,

RT