I need to perform some additional calculations on the results of a pivot table. How might this be possible? The goal is to come up with a value that is this formula:
SUM(Invoice Total) / COUNT (Number of Invoice RefNbr values) for a given customer & time period.
I am struggling to produce this number because of the limitations I am finding within Generic Inquiries.
Similar/Reference posts:
Does anyone know if this is possible?
I also see that other people are attempting to to aggregate functions as a product feature, so please upvote:
Thank you for any suggestions!