Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
leobrand
Contributor III
Contributor III

Pivot table measure

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

1 Solution

Accepted Solutions
Neymar_Jr
Creator II
Creator II

Hi,

Please try this -

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

Thanks,

RT

View solution in original post

1 Reply
Neymar_Jr
Creator II
Creator II

Hi,

Please try this -

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

Thanks,

RT