I have 3 date columns - prior submit date, start date, most recent submit date. I created a detail for each date in my table so that I could drag them into my table that has other objects that were pulled from an incompatible folder.
I want to see all 3 date columns in the report.
- If I filter the table by another detail but include all the possible values in the list, the table gets rid of multi-value dates completely and the associated individual details. 2 of my 3 date columns show up if I do this, but the prior submit dates do not show up in the report.
- If I remove the filter from the table (since technically it shouldn't filter anything if I select all possible values), it "unhides" certain rows and multi-value dates and other individual information are visible.
- If I try selecting "avoid duplicate row aggregation" most of the data in the cells are removed and I'm left with a blank table.
Does anyone know how I can keep all the dates in all the columns and the individual details and get rid of the multi-value? A simple explanation would be helpful as I'm new to webi.
Thank you!
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.