class function and Total

[andyrebs]

Hi!

I made a bar chart, I wuold like to use, as dimension, class function:

=class(?????,$(VClassTotalOrder),'Imp.')

what I write in ?????, if I would have the Total of the order?

I have these data:

N°Order	Product	ProductPrice
11111	Pen	1,00
11111	Rubber	4,00
22222	Paper	3,00
33333	Paper	3,00
33333	Bag	15,00
33333	Pencil	2,00

Thank you!

[swuehl · Accepted solution]

Try maybe

=aggr( class( sum[ProductPrice] ,$(VClassTotalOrder),'Imp.'), [N°Order])

[andyrebs]

Yes, It works!

Thanks