Jump to content

Information designer Filter element with Max Year to use in a Information link


Edwin Rutten 2

Recommended Posts

I want to create a felter element for a infolink

So i want the infolink to only give the FY2020 values, created a Filter Element but i do not know how to do this in the expression %1=Max%1 does not work

Who can help me, ofcouse i can hard filter the FY2020 direct in the infolink but i do not want to drapp all through the DTAP once the FY2021 values become available. so how do i select the max value in an Element Filter

 

 

 

 

FiscalYear

Ref

Value

 

 

FY2019

1565600

XS

 

 

FY2020

1565601

XS

 

 

FY2019

1577562

S

 

 

FY2020

1577562

XS

 

 

FY2020

1577879

XS

 

 

FY2019

1587892

XS

 

 

 

 

 

 

 

FiscalYear

Ref

Value

 

 

FY2019

1565600

XS

 

 

FY2020

1565601

XS

 

 

FY2019

1577562

S

 

 

FY2020

1577562

XS

 

 

FY2020

1577879

XS

 

 

FY2019

1587892

XS

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...