Display column as row
Hello Gurus,
I have a calculated column which actually calculates the average of all the values in 1 category (refer to the example below). So, it actually shows the same average for all the column in that category, which is correct. My problem is I want to show that column as a row so that the average can be shown just once (very similar to grand total)
EX: This is how it is displayed now
Category product Sales(in millions) Avg Sales(in millions)
Category1 TV 12.3 3.5
Category2 TV 2.3 3.5
Category3 TV 1.5 3.5
.
.
.
Categoryn TV 6.3 3.5
This is how I want to display it as
Category product Sales(in millions)
Category1 TV *12.3*
Category2 TV *2.3*
Category3 TV *1.5*
.
.
.
Categoryn TV *6.3*
Avg Sales (in millions) *3.5*
Please help!!!
For some reason, OTN isn't showing correct alignment...
Avg Sales (in millions) should come under Category and its value 3.5 should come under Sales (in millions)
Please let me know if I should make it clearer.
Edited by: Programmer Analyst on May 1, 2013 8:18 AM