March 13, 2007 at 4:55 am
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
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