How to add records of same group

[trishita]

I want to add only the same kind of records.For example want to add records for  ALL RMKs 700 together or  all DMA together.

How can I add such an expression in the chart expression but not in the script...

[ogautier62]

Hi,

why don't you use NI Fuel Type as a dimension ?

regards

[sunny_talwar]

Is Differential Re.... used a dimension? May be remove that as a dimension and that will remove the distinct value of Differential Re... and sum the same NI Fuel Type

[trishita]

I have used it as a dimension.But I am not sure how to write a script or eXpression for it like..I would like to use something like:

if (Fuel_Type)='RMK' THEN sum(Computed ROB) and so on..i want individual addition of the fuel types

[trishita]

i dont know how to sum same type of fuel values in side an chart expression

[sunny_talwar]

Sorry, what?

[trishita]

You wrote to sum the same NI Fuel type..Idont know how to do it in chart expression as i am not able to use the WHERE clause in an chart expression

like how would i write an expression for

select

sum(computedROB),

sum(ActualROB)

where NIFuelType='DMK'

GROUPBY Nifueltype

[sunny_talwar]

You already have the chart created, don't you? All I am asking it to remove the Differntial Re... field from the list of dimensions... does that make sense?

[trishita]

The problem persists

[pradosh_thakur]

Do you have any hidden columns? And i hope Computed ROB, Actual Rob etc are in expression and not in dimension ?

If possible can you post a screen shot of the dimensions and expressions.