Group By and Order By

[Anonymous]

Hello!!

I'am trying to add  A Group By and a Order By to my table, but i receive this error: ' Invalid Expression'

(the only expression is a sum(BankDebt))

Can You help me?

I attached the qvw.

Thanks

Giancarlo

It'S the correct file

[Anil_Babu_Samineni]

I didn't receive any error while reload. Will you provide snapshot for that error

[Anonymous]

Hi Anil, i have uploaded the wrong file..now it is correct...
before the reload isn't break because in the Group By i have insert all dimensions :

Group by  BankGroup, BankDebt, DataAct

But i want only Bank Group in the Group By

[lawrance]

Hi Saturno,

In group by we should use all the fields except aggregated field.

Could you please share the screenshot of that error.

Thanks,

Lawrance A

[Anonymous]

[#6]

Are you  missing a comma after autonumber?

[aarkay29]

Check this

[Anonymous]

thanks but now i don't have any value?!?

[Anonymous]

now comma is there..

[aarkay29]

if this not what you are expecting. Please give a example what you are trying to achieve

Thanks.