Sum in class table

[Anonymous]

Hello for all Qlik mages! 🙂 Can anybody help me with tables? In first table I have prepared data and I need make sum for each "Material" (column Total stock/Psc Per pa) and final sum for each distinct Material get to second table. Where I will see sum in range 0.1. In screen I have filtered only two Materials, but I have it more. In Headers of columns are my used formulas.

[sunny_talwar · Accepted solution]

May be one of these as your dimension

1)

Aggr(Class([Total Stock]/[Psc Per pa]), 0.1), Edate, Material)

2)

Aggr(Class(Sum([Total Stock]/[Psc Per pa])), 0.1), Material)

[Anonymous]

Sunny, you are genius! Thank you. Point 2 work.