I have sample data like below. When i try to make a pivot table with one summarisation filed(Sum). Its absolutely fine. See the screen shot. But When i try to add another summarisation field(Average) , it creates duplicates for each column. See the screenshot. I would like to see Average only once as it displays for Sum. Is this possible in Pivot table ?
enter image description here

Multiple Summarisation fields with no duplicates