Top(Max value) discarding others

[Anonymous]

Hi,

I am attaching the sample app and go through it to find top(Max) values and discarding others in a pivot table

thanks in advance

[ashishkalia]

HI Jonh
Jst do one thing

TAB1:

LOAD GRADE&'-'StartDate AS Key,

          max(Num(EndDate)) AS TopDate

RESIDENT TABLE_X

GROUP BY GRADE, StartDate;

noconcate

LOAD Num#(SubField(Key,'-',0) )   AS     GRADE,

           TIMESTAMP(NUM#(SubField(Key,'-',-1))) as StartDate,

          TIMESTAMP(TopDate) as TopDate

RESIDENT TAB1;

u can DROP tab1 if u want or aliase so that doesnt make synthetic or else

ND NOW U CAN DIRECTLY TAKE THESE FIELDS INTO UR CHARTS.........

CHEERS.

[jagan]

Hi,

Please find attached file for solution.

Regards,

jagan.

[daveamz]

Hi, John!

See the example attached. I used another table based on the resident one to mark the max values and then, in the pivot table, you can simply filter out unwanted values with set analysis.  If you don't need the other values at all, you can INNER JOIN instead of LEFT JOIN.

Best regards,

David