Grand Total not showing the result on Pivot table

[Anonymous]

I'm new to Qlik sense, I used to calculate the weight of the product based on two condition.

1. If unit of measure is Pcs then the Weight = Unit.Wt*Quantity

2. If unit of measure is Kg then the Weight = Quantity.

for this scenario, I used formula as below

if(UNIT='PC',SUM(U.Wt*QTY),If(UNIT='KG',SUM(QTY))). the result seems is Ok for the detail records, but it is not appearing for Grand total and appear as Null value.

Attached the screenshot for your review.

I need to know where is the issue which is not showing the Grand total either from my formula or any short of workaround.

[ieuyar]

Maybe this:

IF(UNIT = 'KG',

Sum( { $< [CUSTINVOICEJOUR.INVOICEDATE.autoCalendar.InYTD]={1},UNIT={'KG'} ,[CUSTINVOICEJOUR.INVOICEDATE.autoCalendar.YearsAgo]={0} > }  [CUSTINVOICETRANS.QTY]*FACTOR),

Sum( { $< [CUSTINVOICEJOUR.INVOICEDATE.autoCalendar.InYTD]={1},UNIT={'*'}-{'KG'} ,[CUSTINVOICEJOUR.INVOICEDATE.autoCalendar.YearsAgo]={0} > } [CUSTINVOICETRANS.QTY]))

[Anonymous]

Not working, the result shows 55.2M instead of 18.2M

[woshua5550]

post your sample app will make it easier to figure out

[Anonymous]

Ok, I'll prepare and send you soon.

[Anil_Babu_Samineni]

You can check my expression, There is no Aggregation field in your set.