conditional sum in pivot

[userid128223]

StudentName	Score	Age
A	55	21
A	43	19
A	55	18
B	55	27
B	43	18
B	44	17
B	33	18
B	43	25

How can i create a pivot with subtotal of score only if Age is less then 20. Sub total will ignore the score for Age higher then 20.

[Anil_Babu_Samineni]

May be this?

LOAD StudentName,

     Score,

     Age

FROM

[https://community.qlik.com/message/1256839]

(html, codepage is 1252, embedded labels, table is @1);

Create Pivot Object and use Dim as StudentName

Expression is Sum({<Age = {'<20'}>}Score)

Go to Presentation tab and check the Partial Sum if you need