Showing only the lowest dimension values

[lblazfer]

Hi all!

I'm trying to implement something in my pivot table, so when one expands a dimension the pivot table only shows the lowest dimension values as follows:

Before expanding dimension "Year"

After expanding the dimension "Year"

Is it possible to do this??

[rui24]

Hello Lblazfer

This expression only show Field1 with the lowest value in Field2 :

FirstSortedValue (Field1, Field2)

This will show Field1 with the second lowest value for Field2:

FirstSortedValue (Field1, Field2, 2)

Try to do some logic to resolve your problem, maybe this is useful

[Anna_Canepa]

Hello Lblafzer

you can try with RowNo()

Example;

Load * inline

[Year,Country,quantity,

2014,Italy,5,

2014, Germany,25

etc]

and define the measure    if(RowNo()>0,sum(quantity))

I hope it helps.