Summary of using Max/Min in form of Straight table & collapsible sections

[klrameet]

Hi

I am trying to create a summary of data, in to a straight table, using max/min values of some columns.

e.g: from the data table on left, i am trying to populate summerized table, on right, where i intend to display only those rows, for names where version is MAX and Rank is MIN, rest of the columns with matching data.

and the subsequent details in collapsible sections. ..

is there a way to put to it in Pivot Kind of a look, where if expanded each subsequent details for the Name would appear, otherwise just displaying the latest (max version and min rank)

Appreciate any help. stalwar1‌ kush141087‌ gwassenaarswuehl

[sunny_talwar · Accepted solution]

May be use this as an expression rather than dimension

Max(Version)

or you can try this as your calculated dimension

Aggr(If(Version = Max(TOTAL <Name, Source> Version), Version), Name, Source, Version)