Forum Discussion

DrewSmith's avatar
DrewSmith
Helper III
2 years ago
Solved

Text box with dynamic value

I'm currently using a text box as a header with a dynamic value based off of my customer name.  This works when I'm filtering on the customer name, it comes up:  Sales Overview - Andrew Sales Ov...
Need Help
  • Alf94's avatar
    Alf94
    2 years ago

    Hi DrewSmith ,

     

    Have you tried something likethe following?

     

    IF(
  ISFILTERED(Customer),
  SELECTEDVALUE(Customer),
  'All'
)

     

    If I answered your question, please mark my post as a solution.

    Best,

Alf94's avatar
Alf94
Solution Supplier
2 years ago

Hi DrewSmith ,

 

Have you tried something likethe following?

 

IF(
  ISFILTERED(Customer),
  SELECTEDVALUE(Customer),
  'All'
)

 

If I answered your question, please mark my post as a solution.

Best,

  • DrewSmith's avatar
    DrewSmith
    Helper III
    2 years ago

    Genius - popped that in as a measure and worked first time. Nice!