Return just one row in my report

Gopikrishna Mamidipudi

I wanted to create an ability in my Workapp or Dashboard that would pass the filter criteria to a Report and show only the filtered rows. Is that possible? Is there a workaround?

Michelle Choate 2

Are you looking to return the newest row or a chosen row? Could you create a column that is a checkbox that says "Show In Report" and then base your report filter off of this column?

Gopikrishna Mamidipudi

I have a sheet with 10K rows. The sheet has a column called TitleID.

There are multiple rows in the sheet for each TitleID.

I have reports that show a list of all rows with a TitleID.

If the TitleID is "ABCD" I have created a report called Report-for-ABCD.

If the TitleID is "UVWX" I have created a report called Report-for-UVWX.

I have 150 possible values for the TitleID, and hence 150 reports. Each of these reports have the Filter set to the specific TitleID.

I want instead to have just ONE report and the user specify the TitleID. This TitleID should be passed as a parameter to the Report and set the filter to that specified by the user and display the report appropriately. Is that possible?

kowal

Hi Michella,

Unfortunatelly the Reports do not have dynamic filters :(

all you can do is to group by TitleID so somehow it will close or open the hierarchy based on this column.

Maybe you can post this idea to Product Ideas part of this Community?

Gopikrishna Mamidipudi

Can I use Bridge to achieve this?

Jason Tarpinian

I don't know Bridge, so can't answer to that, but I've seen a solution in which you create a form an a separate sheet where you could select the "TitleID" you'd like to see filtered to. Have that form place newest requests at the top.

Then on your main sheet, build a checkbox formula with the following formula. This will then check the box of your main sheet with the latest form requested TitleID. I've done this before as a way to "dynamically report" on dashboard, BUT IT'S SLOOOOOOOOOOOW. Which isn't bad if you're going to be changing the TitleID every once in a while. But if you want to use it as a way to quickly bounce around during a meeting, it takes about a minute or more for the form + formula + report to all catch up.

=IF(INDEX({Form TitleID},1)=TitleID@row, true, false)