Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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])
Hi,
Please try this -
count([Dinosaur Type])/aggr(nodistinct count([Dinosaur Type]),[Century Named])
Thanks,
RT
Hi,
Please try this -
count([Dinosaur Type])/aggr(nodistinct count([Dinosaur Type]),[Century Named])
Thanks,
RT