Group data in pivot table

[paolojolly]

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