total group basis problem

[#1]

hi,

I need me I'll write a formula in a pivot table in expression .

thanks.

please help me

[sunny_talwar · Accepted solution]

May be like this:

Sum(Aggr(Sum(quantity) *(Sum(time)/Sum(TOTAL <grp> quantity)), grp, Customer))

[#3]

Thank you very much

[sunny_talwar]

Did it work? If it did, please close this thread by marking correct answer.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny

[#5]

My friend hello,I needed help again. I had a date information in a column in this example.Can I also add the month value of the date information that pivot condition.

You have to reach a conclusion as in the following example.

required results :

Total
	month
Grp	January	February
A	18	20
B	30	22
C	20	25
D	15	28

I thank you in advance for your help.

[#6]

my real code :

if(Dimensionality()=0,null(),

  Sum(

      if(lotmaster.MIKTAR>1 and not WildMatch(lotmaster.TED_LOTU,'*(*'),

       if(not WildMatch(lotmaster.TED_LOTU,'   *'),

           Aggr(sum(lotmaster.MIKTAR) *(sum(TARIH-lotmaster.TED_LOT_URETIM_TARIH)/Sum(TOTAL <lotmaster.ISEMRI_UG> lotmaster.MIKTAR)), lotmaster.ISEMRI_UG, lotmaster.LOT_NO)

        )

      )

     )

   )

[sunny_talwar]

Are you sharing it with us or are you still having issues Kadir?