Skip to Content
0
Former Member
Feb 24, 2011 at 02:27 PM

Sum for new aggregation

34 Views

Hi all,

I've dimension [Name] and measuse [Cost]

Now I've created a new variable [CATEGORY] that aggregate [Name] dimension.

example

CATEGORY=IF([Name] InList ("Smith","Anderson"); "Sales"; IF([Name] InList ("Carlson", "Tery"); "Marketing"; IF([Name] InList ("Pollock";"Gin"); "Production; "Other")))

Now in new tab of my report I would like new table [CATEGORY] and [Cost]

but the cost is not the aggregation SUM for each category row, but is total sum of all cost.

I tried to write in each row:

Sum([Cost] ForEach [CATEGORY])

but don't work fine!!!

Any ideas?

Thanks