Turning in circles here and going crazy- I created a contribution page with a price set that includes numerical fields when guests want to purchase multiple individual tickets for our upcoming gala, in addition to radio button options.
Nowhere am I able to create a contribution report that exports the total transaction amount and the value for this numerical field. For example, I want to quickly see that $1800 = 2, $900 tickets. So I will need the item price $900, quantity =2, and total = $1800.Obviously I can infer this but I want to export this quickly and frequently and be able to forward to my team without manual manipulation.
I've tried a contribution details report, find contributions, and a Civi bookkeeping transactions report with filters by my target financial type. None of these options are giving me the data I need. I thought this was a relatively simple ask...but not with Civi...I contacted our support who was also stumped and advised to use pivot charts which I'm not an export in. I also tried IF formulas in excel and I have too many criteria. I just want my simple registration data.
...can anyone point me in the right direction?...