Hi Community!
I have created a pivot table that counts Orders and Lines per day. How can I then add a column that averages the two totals in the pivot table or is this something that can only be done using Velixo?
Answer
Averaging in a Pivot Table
Best answer by lauraj46
Hi
You can add these fields a second time by dragging them onto the Values area, then set the Aggregate function to Average. Hope this helps!
Laura
+8Hi
You can add these fields a second time by dragging them onto the Values area, then set the Aggregate function to Average. Hope this helps!
Laura
Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.