Lina Antelmann Posted March 28, 2019 Share Posted March 28, 2019 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 More sharing options...
Richard Pobi Posted March 28, 2019 Share Posted March 28, 2019 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 More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now