Skip to main content
Announcements
WEBINAR April 23, 2025: Iceberg Ahead: The Future of Open Lakehouses - REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
AO1
Contributor II

GetFieldSelection not working with a Pivot Table

Hi, 

I am working on a basic dynamic title to go along with my pivot table. I want to show the Staff Name and Service Dates in the title when selections are made in the pivot table. 

I am able to get the Service Date to be part of the title by using GetFieldSelections([Services.Service Date]) expression. However, that same expression does not work for Staff Name. 

Here is the expression I have entered:

AO1_1-1733930868762.png

I want to show the Staff Name that is selected in the pivot table below. 

AO1_2-1733931045263.png

I do not get an error in the expression, however, nothing is returned when a Staff Name is selected. It is not reflected in the title. 

I have tried several different alternatives to GetFieldSelection including Concat (which returns ALL of the Staff Name until a selection is made), GetCurrentSelections (which does show the Staff Name, but also shows the Service Dates and looks messy in the title). 

Any advice is greatly appreciated!! Very confused why this expression would be working for one field and not another when they are referencing the same pivot table.

Any advice is greatly appreciated!!

Thank you.

 

Labels (2)
2 Replies
David_Friend
Support

marcus_sommer

Make sure that you really reference to the right field and not a similar one or to the label of field. Another look might go if it's a native field and not calculated one.