Forum Discussion
Helper IIIRemove Repeating Values in a Table Visualization
Super UserJRParker use matrix visual, add lead_name and activity_note on rows, click drill down button, on format pane, turn off stepped layout and you will have the view you are looking for.
JRParkerCouldn't get this to work in the following scenario when the 'many' side has two fields (Note, Activity)
Lead Note Activity
Lead 1 Note 1.1 Phone Call Lead 1 Note 1.2 Phone Call Lead 1 Note 1.3 Phone Call Lead 2 Note 2.1 Meeting Lead 2 Note 2.1 Phone Call Lead 3 Note 3.1 Phone Call Lead 3 Note 3.2 Meeting Lead 3 Note 3.3 Meeting Lead 3 Note 3.4 Meeting Desired outcome:
Lead Note Activity
Lead 1 Note 1.1 Phone Call Note 1.2 Phone Call Note 1.3 Phone Call Lead 2 Note 2.1 Meeting Note 2.1 Phone Call Lead 3 Note 3.1 Phone Call Note 3.2 Meeting Note 3.3 Meeting Note 3.4 Meeting Thanks again parry2k!
Colleagues,
The solution provided does work, but there is one problem with it: The Matrix View does not appear to allow Horizontal scrolling. In my situation, there are more columns to display than there is space on the page. With a table, I can scroll to the right. In a matrix I cannot.
Am I missing a setting that does allow Horizontal scrolling in the Matrix View, or is there now some other way to use the Table Visual and remove repeating information?