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