Group data in pivot table

paolojolly — Fri, 11 Jul 2014 14:35:18 GMT

Hi I'm new in Qlikview and I need help to create from the excel file attached a pivot table with in expression a value like this

(

sum(

if (W_TOT_KG_CAMP >= 0.01,

(W_PREZZO_NOCOMP * W_TOT_KG) - W_TOT_IMP_RIGA

)

sum(

(W_PREZZO_NOCOMP * W_TOT_KG)

)

(

//the value of

sum(

if (W_TOT_KG_CAMP >= 0.01,

(W_PREZZO_NOCOMP * W_TOT_KG) - W_TOT_IMP_RIGA

)

sum(

(W_PREZZO_NOCOMP * W_TOT_KG)

)

//for the group D_MARCHIO_STAT,D_CANALE_PADRE_STORICO,CD_LINEA_FAT

//making sure that If I select an item from Customer selection box the value of this group

//should be not only the value of the selected Customer but the sum of the value of all Customer

//that have the same D_CANALE_PADRE_STORICO of the selected Customer

)

To get the value of the group is correct to use

max(

Aggr(

sum( TOTAL <D_CANALE_PADRE_STORICO,C_LINEA_FAT> {$<CD_CLIENTE = >}

if (W_TOT_KG_CAMP >= 0.01,

(W_PREZZO_NOCOMP * W_TOT_KG) - W_TOT_IMP_RIGA

)

sum( TOTAL <D_MARCHIO,D_CANALE_PADRE_STORICO,C_LINEA_FAT> {$<CD_CLIENTE = >}

(W_PREZZO_NOCOMP * W_TOT_KG)

)

, D_MARCHIO, D_CANALE_PADRE_STORICO,C_LINEA_FAT)

)

I attach a sample document

Can someone help me?

thanks

topic Group data in pivot table in QlikView