Hello,
I'm using a relational model. This is a list report. I've created two queries and joined them with a one to many relationship.
I created several custom data items for each year to look through all previous donations. If someone donated in 2010 then Y else N, etc. Because a person can have multiple donation records, I'm getting multiple rows. But I just want to see one row for one person on the output with Y or N going across.
I'm attaching a screen shot of what I'm getting and what I'd like to achieve.
Thank you.
My tablet would not open your attachment.
Try a query to aggregate the desired measure Total.
A simple way is to use max() on yearly data item value partitioned by year.
Thank you for your responses.
Can I use max on a Y/N data item?
I changed each FY custom data item to return a 1 or 0, then changed aggregation to total for each. Then I created a layout calculation to display either a Y or N across the row. Time consuming but it's working.
Boksberger, I tried the max function on each FY data items. And it worked! Thank you.