Post reply

Filtering Results

  • March 13, 2007 at 4:55 am

    #117897

    Hi.

    I have a report that I'm trying to build that runs a query and collects data for the current month, from the 1st until today's date. In the layout I have multiple tables that shows various info based on that resultset.

    One the tables I am trying to get to show only yesterdays information (kinda like a summary for yesterday's data only) - so I am guessing I would need to use a filter for the dates in that table. I have a column of transaction_types, and then two sub-column underneath called transaction_count and total(£). I think, if I am not mistaken, that a filter would need to be applied to two sub colummns?

    I'm just not sure what that filter should look like!?

    Any ideas?

    Thanks,

    David

  • March 13, 2007 at 8:00 am

    #694690

    Found a workaround:

    In the same report, create a new Dataset, using the same Data Source, and run the same query limiting it to only yesterday's date, and then reference that dataset for that particular matrix.

    David

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply