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

Marking applied to a field, not specific rows

Scott Thompson 4

Recommended Posts

I have a cross table setup that has spend by factory by quarter, and say I mark a particular factory for 1Q19. I have another table based on this marking that shows me spend by material in 1Q19. Now, what I want to be able to do is mark one of these materials (say, the highest runner) and have another visualization automatically pivot to show me that material's spend across time. I can't figure out how to do this...if I base that visualization on my second marked visualization...that one was filtered down from only 1Q19 and only has the rows for 1Q19...not across time like I am trying to see. Is there a way to "mark" that second visualization table but have it only feed the Material name into the Material field in my third visualization...so that this table can look across time
Link to comment
Share on other sites

  • 2 months later...
You can setup a data function to capture marked field value and set it as document property value. Once the document property value is set, you can use that in data limit expression of third visualization like [Material]="Wood" and do not limit it by any other marking then you can get trend for wood not just specific Q1 data
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...