Conditional Sum

[dhirajkhodade]

I have table A

Department Income Type

Comp               100         A

IT                        200         A

Mech                 300         B

Prod                  200          C

EnTC                  100          B

and I want to show total of Income per type in another table B

Type  Total

A           300

B           400

C            200

So how can I show conditional sum of field from one table in another table

[Edvin · Accepted solution]

Try creating a dimension like:

=aggr(sum([Income]),[Type])

And create a new table with this new created dimension and [Type] field

[shiveshsingh]

Hi

In Script:

A: load Your Table

B:

load Sum(Income) as TotalIncome,Type
Resident A
group by Type;

In Chart:

Dimension : Type

Expression : Sum(Income)

[ravi200351023]

=sum(distinct aggr(nodistinct sum([Income]),[Type])))