Create a table with filters in inDesign

[Tania5C22]

Is it possible to have a table that filters data (like excel does)? It will be to export as an ePub document.
Thank you!

[Steve Werner · Accepted solution]

As a happy non-regular user of Excel, I'm guessing here, but I think you want a formula to be applied to a cell. InDesign, not being a spreadsheet application, doesn't do that. What you see is what you get.

[Chad Chelius]

Steve is spot-on with his answer. You'd need to filter it in Excel first, then place it into InDesign.