Hello,

I have created my pivot table with this MS Access query ,

transform max(value)

select hour from mytable group by label

pivot label

below is the Table output from pivot table query :

Hour A B C

1 15 14 21

2 22 23 24

3 21 33 11

4 10 10 10

I would like to added one columns with this simple formula (A+B +C )/

3

so the output like this.

Hour A B C Avg

1 15 14 21 16.67

2 22 23 24 23

3 21 33 11 ....

4 10 10 10

based on that formula .. Is there

a way to do that?. Please let me know.

Thanks in advance

Simpler might be

TRANSFORM Max(Value) as TheMax

SELECT Hour, Avg(Value) as TheAverage

FROM MyTable

GROUP BY HOUR

PIVOT Label

By the way, posting the actual query string makes life a lot easier. Your

posted "sample" contained an error that would generate a syntax error.

John Spencer

Access MVP 2002-2005, 2007-2008

The Hilltop Institute

University of Maryland Baltimore County

TRANSFORM Max(Value) as TheMax

SELECT Hour, Avg(Value) as TheAverage

FROM MyTable

GROUP BY HOUR

PIVOT Label

By the way, posting the actual query string makes life a lot easier. Your

posted "sample" contained an error that would generate a syntax error.

John Spencer

Access MVP 2002-2005, 2007-2008

The Hilltop Institute

University of Maryland Baltimore County

1. Adding a summary column to a pivot table query

2. add a column to a pivot table that would show the difference between 2 other Columns

3. Using A Pivot Table Running Total in a Pivot Table Formula

4. Pivot Table - Adding a % of Total Column along with Grand Total column

5. Filter lines with Pivot table and non pivot table columns

6. Filter lines with Pivot table and non Pivot table columns

7. "Pivot Table" option in Add / Remove buttons for Pivot Table Toolbar

8. Pivot Table Data Adding contents of two pivot tables and param que

9. Possible to create formula columns within Pivot Tables?

10. Can I have a different formula in a subtotal column in Pivot Table

11. Additional column formula in pivot table

12. PIVOT TABLE with a MACRO for FILLing a column with a formula

13. Using 'The count of' column in a pivot table formula

14. How do I use a count query formula in a pivot table?

15. How do I add a formula to activate a pivot table list??

2 post • Page:**1** of **1**