Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
klrameet
Contributor III
Contributor III

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

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. ..

Capture4.JPG

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. stalwar1kush141087gwassenaarswuehl

1 Solution

Accepted Solutions
sunny_talwar

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)

View solution in original post

1 Reply
sunny_talwar

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)