Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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).
Try using Pivot table instead.
It is achievable, share some sample qvw, if possible.
Create a Straight Table
Dimension = No Dimension
Expressions
SUM(Amount)
SUM({<Year = {'$(=Max(Year)-1)'}>}Amount)
SUM({<Year = {'$(=Max(Year))'}>}Amount)