Jump to content
We've recently updated our Privacy Statement, available here. ×

How to limit Data in Waterfall Chart with Dropdown Menu

Lina Antelmann

Recommended Posts

Hello, I have a dropdown menu that shows"unique values in column" from an excel sheet. (name: "sourcemarketsdriver" data type: string). Now I want to apply the choice made there as a filter to my waterfall chart, so that it only shows values that match the calumn value choosen in the dropdown menu. I would be very happy for any suggestions on how to solve this. Thanks! Lina
Link to comment
Share on other sites

I'm assuming you have already created a property control by the name "sourcemarketdriver" as your document property. If yes, then the next step is. Right click on your Y-axis, select custom expression, write the following expression. Sum(If([ColumnX]="${sourcemarketdriver}",[Column Values]))

ColumnX is the column with the unique values.

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...