Sum using Date and Category filters

[SteffanieJ]

Hello! 
I am new to Qlik and I am struggling to find the correct formula to use in my measure.  I need to get the Sum of Pounds by Date and Category. I am using a pivot table and filtering by the date.

Here is the formula I currently has but it is returning data that isn't accurate.

sum(aggr(max([Daily ZINV2.Download Date],[Material-Material]),[Daily ZINV2.Pounds in Inventory]))

What is the best formula for this?

[Chanty4u · Accepted solution]

Try this

Sum([Daily ZINV2.Pounds in Inventory])

And use your pivot table dimensions like:

Daily ZINV2.Download Date (as row or column)

Material-Material or Category as dimension

Or

If you want aggregate use this 

Sum(

  Aggr(

    Sum([Daily ZINV2.Pounds in Inventory]),

    [Daily ZINV2.Download Date],

    [Material-Material]

  )

)