Totals in Pivottable

[francisvandergr]

I have a pivot table with the following columns :

Debtor, period

When i select Year 2010 i see the periods 1t/m 3. This is good. But i want a extra columns

One with total sales of the debtor in the Year 2009 and a column with total sales in 2008.

How can i achieve this?

I attached an example database

[Miguel_Angel_Baeyens]

Hello Francis,

Perhaps this?

Sum({< Year = {2009} >} TOTAL <Debtor> Amount)

and

Sum({< Year = {2008} >} TOTAL Amount)

Hope that helps

[francisvandergr]

Thanx for your reaction Miquel. But this is not what i means. The problem is that i get a column for each selected period. I want one column for whole 2009. I attached a new file with my new situation.

[Miguel_Angel_Baeyens]

Hello Francis,

Check this one. The only way to get this in only one column is to remove Period as dimension and set one dimension per period.

Hope that helps

[francisvandergr]

Thanx ! Almost 🙂 The only problem is that i want for 2010 is only see the seleected periods. And when i select a period. I want see all sales for 2009 and not only for the selected period.

[Miguel_Angel_Baeyens]

I think that this fixes the problem.

Anyway, take a look at this qlikview about date ranges, that may be helpful.

Hope it helps.

[francisvandergr]

Hi Miguel. Not at all, but i will read Set Analyses very good. You helped with a good document and i have almost the solution. Thnx