Aggregation

[johnso2080]

Hello,

I have a table like the below....

Model	Item	Colour	Views
A	1	BLUE	4000
A	1	GREEN	4000
A	1	BLACK	4000
A	2	BLUE	1200
A	2	GREEN	1200
B	3	RED	2600

What I want to do is add up the 'Views' for each model, but removing the duplication by colour.

So that the total views for item '1' = 4000, and item '2' = 1200 so the total for model 'A' would be 5200.

I've tried a couple of different Aggr() formula variations but I'm having some trouble! Any advice would be much appreciated!

Thanks

Darren

[#2 · Accepted solution]

Per Model and Item:

AGGR(SUM(DISTINCT Views), Model, Item)

Per model:

AGGR(SUM(AGGR(SUM(DISTINCT Views), Model, Item)), Model)

[johnso2080]

Thank you very much!