How to stop row aggregation?
I have a table of case details. It’s currently set up with all the dimensions necessary in Rows: Case number, subject, created, state, etc. Nothing is in columns and only “Hide abc” is in the text marks to hide that “abc” that tableau defaults to in tables. The issue is that one case number can have multiple subjects involved. My data source already configures that correctly in excel, where case #123 is repeated X amount of times - one per subject. However, in Tableau it’s showing the case number, created date, and state once, but then subjects and everything else onwards X amount of rows according to subject person - see attached photo.
I’ve already tried unchecking “aggregate measures” under “analysis” but that didn’t work. I don’t recall ever running into this issue before.
I want it so that each row lists the case number, created date, and state repeating according to each subject person. And the columns have to be in this order, is there a simple fix for this?