adding an extra calculated dimension

[#1]

Hello All,

I have a problem with a table like this.

Month	Person	Cost
1	A	10
1	B	10
2	A	5
2	B	15

I try to create a pivot table like this ;

I can do it with excel by creating calculated item in PivotTable. Is there anyway for this in Qlikview PivotTable

[Gysbert_Wassenaar]

Use Month as Person as dimensions in the pivot table. And enable the Indent Mode and Use Only First Dimension Label options on the Style tab.

[#3]

Thanks for quick reply, but my problem is different.

As you see ; I add extra calculated dimensions Month Names.

January  ; has only January's values.

February ; has both  (January & February) values.

March ; (Sum of March & earlier month records)

[Gysbert_Wassenaar · Accepted solution]

You need to create an extra table for that:

NewMonths:

LOAD * INLINE [

NewMonth, Month

1,1

2,2

January, 1

Februari, 1

Februari, 2

];

Then use NewMonth as dimension instead of Month.