need help to create table like attached image

[ananyaghosh]

Hi,

I have attached an excel sheet and based on that I have to create a table like this:

Where

KIP = Value Per SQ Ft and other columns behind the Value Per SQ Ft.

Please give me a suggestions

[Anonymous]

It looks like a pivot table with dimensions KPI Name and Quarter, and expressions Portfolio and Bench mark.

[#3]

The only tricky part is maybe the dimensions sorting but that should be manageable with the expression sort. 

[ananyaghosh]

Can u give me QVW showing the table in proper format? the main problem is showing two header under a main header for example 2015 Q2 have two sub heading portfolio and benchmark.

[Anonymous · Accepted solution]

See attached

Two dimensions, one of them is on top (Dim3), and two expressions.

[#6]

Couple of QVW example here

Re: Merge headers in pivot table

merge headers in pivot table

Best one which i like personally, and is simple to understand is

Re: adding manual field header to pivot table

Multiple Header Rows.qvw

Hope this helps...

Regards,

KC

[ananyaghosh]

Hi,

How can you create Three columns X, Y and Z in pivot table? Can u give me some screenshot, how to do it? because you have specified only two expressions and that expressions are repeated for X, Y and Z columns. So please give me some instructions of how to do it.

Please....................