Aggr function

[#1]

i have the following data.

Entry No	Item No.	Sales	Cost
1	a	100	20
1	b	100	10
1	c	100	20
1	d	100	30

Since entry No. is constant, i want Total sales of 100, but the cost should be 80.

What function can i use.

I tried aggr function. but it is not working.

[sagarkharpude]

Try nodistinct

[PrashantSangle]

Hi,

Create Straight table

take

Dimension => Entry No.

Expression

1: Aggr(Concat([Item No.],','),[Entry No])

2: Sum(Distinct Cost)

3: sum(Cost)

Regards

[giakoum]

In a chart with Entry No as dimension :

Expression for sales : min(Sales)

Expression for Cost : Sum(Cost)

But what is your requirement exactly?

[sunny_talwar]

For cost you can use this may be:

=Sum(Total <[Entry No]> Cost)

Best,

Sunny

[MK_QSL]

=SUM(Aggr(SUM(DISTINCT Sales),[Entry No]))

and

=SUM(Aggr(SUM(Cost),[Entry No]))

[avinashelite]

Try like this:

Aggr(sum(Cost),[Entry No])

[hic]

For the Cost, you should use

   Sum(Cost)

But for the sales, I must ask: What is the logic?

If one Entry Number has several sales values - which should you pick? The average?

Further, should the sales number be summed for different Entry Numbers? If so, you should use

  Sum(Aggr(Avg(sales), [Entry No]))

HIC