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: 
Not applicable

Show textual name and minimum value in a pivot table cell

Let's have a hypothetical widget purchasing company... they buy widgets in different shapes and colors

per shape and color we would like to show the top 3 purchases ranked by the lowest price per shape.

Example output I would like to produce...

ovalroundsquare
blue1

john

125

jack

350

pete

235

2

jack

140

john

352

claudia

243

3

claudia

150

pete

356

john

255

red1

etc.

2
3

Any help on how to fix this would be great... thanks....

1 Reply
Not applicable
Author

Can you please share some sample data for your requirement?