Question about Pivot table

[francisvandergr]

Ha,

I have a pivot table which works as follow when i select in the table asofmonth a period i see in my pivot table the last 24 months in the order i want.

What i extra want in this table is in column1 the following: when i for example choose "Aug 2010" i wanna see in colum1 the total sales from "jan 2010 till till aug 2010"

Is this possible in this pivot table

[Gysbert_Wassenaar]

Try this as calculated dimension: =aggr(sum(if(MonthYear>=YearStart(AsOfMonth),Sales)),AsOfMonth)

[francisvandergr]

Thnx for sofar ! Is this also possible with set analysis? I understand that i can better work with set analyse in qlikview as with if statements for a better performance

[Anonymous]

Hi,

i think it is possible in pivot table,

but you need to wrote a two expression for single mesures

EX:

if(getfiledselectedcount(myfieldname)=0,then your 24 months expression,

you current ytd expression)

EX1:

you can handle in varibles also

write a variable based on selection,

create a two variable for VarMIndate and VarMaxDate

any month or year selection hapeen take Min and Max date varibale for current ytd other wise 24 months Min and Max date variable in expression.

Regards