topic Re: Showing only the lowest dimension values in App Development

Showing only the lowest dimension values

lblazfer — Mon, 30 Jan 2023 11:33:50 GMT

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

Re: Showing only the lowest dimension values

rui24 — Wed, 08 Feb 2023 08:30:54 GMT

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

Re: Showing only the lowest dimension values

Anna_Canepa — Fri, 10 Feb 2023 16:18:17 GMT

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.