Add column in pivot table / Average

[Theo_Westseit]

Hello Guys,

i have a pivot table with the following three information:

Name (Dimension)
Month (Column)
Numbers (Values)

		Month
	Jan	Feb	Mar	...
Name 1	Number 1	Number 2	Number 3	...

Now i want to add a single column after the last month (December) and calculate/display the Average value from Number 1-12.

		Month			Average
	Jan	Feb	Mar	...
Name 1	2	1	1,5	...	1,5

How do i add the single column on the right side an how to calculate the Average value?

Thanks in advance!!

[jmartineze]

hi,

i think the best and easy solution is use a straight with one measure for each month and add average measure. Also you can give a displey condition if you need.

[Theo_Westseit]

Thanks for your reply.

Unfortunately, im using more dimensions and need to stick with the pivot table...
Do you see a possibility to do this with a pivot table?

[jmartineze]

First off all is not posible. But you can do something in the script that allows your goal.

Maybe you can calculate average for name1 in the script and rename average as month. Or generate the complete table in the script and show it. 

[Theo_Westseit]

Thats a good idea! Thanks.