Skip to main content

Announcements
Week 3: High-Volume Iceberg Ingestion and Smarter Data Prep - WATCH NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Dropdown Select can't filter because expression use if function

Hi Guys,

Please help me,

I want to select records on the field in a pivot chart, but the results did not change because the expression tab I use the if function.

Regards,

3 Replies
sushil353
Master II

Hi Valdi,

Share your expression for more clarification.

sujeetsingh
Master III

Need more words to know your need.

Not applicable
Author

My expression:

num(sum({<MAP_0={'P/L'},MAP_4 ={'OACQ','Management Expense'}>}AMOUNT*-1))  and then I can't filter Map_4 on Pivot table