Question on aggr function as facing issue in calculations

[bushpalaamarnat]

I have used following formula

aggr(Sum([Net Inventory]),Brand_Site)

and

Sum(total <[Market 2]>[Net Inventory])

am trying to calculate (brand total per site/ total site)*100.

when am selecting dimension brand the calculation dont happen? if i select site the formula Sum(total <[Market 2]>[Net Inventory]) works and the other one does not. this is wise versa issue.

[tresesco]

Open this thread from the browser directly (and not from Inbox), then:Qlik Community Tip: Marking Replies as Correct or Helpful