I have contribution items in a single contribution report and need to show a quantity of an item purchased in a month.
What is the ideal way to get quantity used for a month in multiple contributions.
I dont see the option for the same.
CiviCRM Stack Exchange is a question and answer site for administrators and users of the CiviCRM Constituent Relationship Management software. It only takes a minute to sign up.Sign up to join this community
I believe what you are referring to are line items - if the contributions in question are event contributions, then you can use Extended Report - "Participant Line Items" that will allow you to filter by event, otherwise, Extended Report - "Contributions with Price Set Data" should also show you what you need- but it may take a bit of trial and error, i.e. the report offers several grouping options for line items:
You'll want to select whatever option(s) you are grouping by as display columns as well as the following columns:
E.g. Grouping by Price Field Option (line item) will yield the following:
Hope this helps! Tamar