Discussion board where members can learn more about Qlik Sense App Development and Usage.
Here is a sample of my data
I am trying to turn it into a pivot table like this
How do can I modify this expression as the measure in the pivot table to do that?
([Dinosaur Type])/count(total [Dinosaur Type])
Please try this -
count([Dinosaur Type])/aggr(nodistinct count([Dinosaur Type]),[Century Named])
View solution in original post