Is there any way to display "nth Payment" of a recurring series? I am looking for a way to display with a contribution and/or line item result that this is the 3rd, 4th, 5th payment in the recurring series. I can work with either a civi report or a Drupal View.
1 Answer
I was able to do this with a Drupal View and adding the Views Aggregator Plus module.
I created a view using Contributions. The format was Table with Aggregation Options. I added the Filter Criteria and Fields that I wanted to display.
In the Format:Settings--
- I "grouped and compressed" the Recurring Id field
- "Count" the Contribution ID field (this column is labeled # of Payments)
So my view displays the Recurring Id with the # of Payments