sum values on table

[rafael5958]

Hello, I have, for example, a xls like this:

customer	customer ID	Company	Supplier	Suplier ID	Value
Kurt	1	AAA	Kmart	1	200
Kurt	1	AAA	Kmart	1	300
Kurt	1	AAA	Kmart	1	300
Kurt	1	AAA	Kmart	1	300
Kurt	1	AAA	Kmart	1	300
Kurt	1	AAA	Gmart	2	150
Kurt	1	AAA	Hmart	3	23
Kurt	1	AAA	Jmart	4	50
Dave	2	AAA	Kmart	1	10
Dave	2	AAA	Gmart	2	10
Dave	2	AAA	Hmart	3	10
Dave	2	AAA	Jmart	4	10
Chris	3	BBB	Kmart	1	50
Chris	3	BBB	Gmart	2	50
Chris	3	BBB	Hmart	3	50

and I need to put this in a table like this:

Supplier	Suplier ID	Diferent Customers	Different Companies	Total
Kmart	1	3	2	1460
Gmart	2	3	2	210
Hmart	3	3	2	83
Jmart	4	2	1	60

How can I do it, Im trying in a dinamic table, but couldnt figure it out, how can I do all the sum.

Thanks.

[sunny_talwar · Accepted solution]

This?

Dimensions: Supplier, Supplier ID

Expressions:

1) =Count(DISTINCT customer)

2) =Count(DISTINCT Company)

3) =Sum(Value)