Dimensionless Straight Table

[Anonymous]

Hi, Can any one tell me how to display straight table with one of its column as a KPI and the following columns displays its measures.

Eg. 1st column-Total Sales Volume(as rows) as a KPI(column header), 2nd Column-Previous Year's Sales(column header) as a measure(as rows), 3rd column-Current Year Sales(column header) as a measure(as rows).

[#2]

Try using Pivot table instead.

It is achievable, share some sample qvw, if possible.

[MK_QSL]

Create a Straight Table

Dimension = No Dimension

Expressions

SUM(Amount)

SUM({<Year = {'$(=Max(Year)-1)'}>}Amount)

SUM({<Year = {'$(=Max(Year))'}>}Amount)