sum values on table

rafael5958 — Fri, 04 Sep 2015 19:42:37 GMT

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

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

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

Thanks.

Re: sum values on table

sunny_talwar — Fri, 04 Sep 2015 20:23:36 GMT

This?

Dimensions: Supplier, Supplier ID

Expressions:

1) =Count(DISTINCT customer)

2) =Count(DISTINCT Company)

3) =Sum(Value)