I have a Crosstab with two weeks worth of data summarized into two column one based on week id, the other a total for the row. I am wanting to filter out any row that Total(week Id) is greater than some threshold value. I have tried using summary filters, but apparently I am doing something wrong because they appear to be doing nothing to the dataset. So...How can I filter a row in a crosstab based on a summary column?
Hi,
Are you using a Dimensional or Relational package? How is your total being calculated? What are you using in the rows?
We need to know what's in the rows because we will be excluding any row that doesn't match your required threshold...
Cheers!
MF.
Data is coming from a relational database. Totals are being calculated by CER using an 'Edge Summary'
This report is a summary of hours with charge EmployeeId/PayType/ProjectId codes as the rows and WeekId and days as columns with the hours being the measure (see image)
I'm just now getting back to this. Can anyone help me out here? I'm trying to wrap my head around this and it just is not happening. help?