Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Try maybe
=aggr( class( sum[ProductPrice] ,$(VClassTotalOrder),'Imp.'), [N°Order])
Try maybe
=aggr( class( sum[ProductPrice] ,$(VClassTotalOrder),'Imp.'), [N°Order])
Yes, It works!
Thanks