Display first or last member of a list using Text Guage

It is often to display either the first or last member of a list in a dashboard using Text Gauge so here is an example:

Here is a list of periods

The MDX Expression to display the first member of the list:

     [Default.Period].children.item(  0  ).name

The MDX Expression to display the last member of the list:

     [Default.Period].children.item(  [Default.Period].children.count - 1  ).name

Results:

 

 

 

 

 

 

 

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.