Analytics Software

Hello every one,

I am trying to create a percentage using the table, but when I am using the pivot table I could able to create it using show data as->percent of->column. but here I am getting in the table as

Operating unit in th second row, and all other measures in the first row.

can we have the operatingunit and measure in the same line in pivot table. If not
Can we create this percentage value using table.(I didnot see the option for this table view).

Can any one help me which case is possible, and is there any ways that we can eliminate the two blank rows when we creat a pivottable or a table.

Thanks.