Avatar

Level 2

Hi All,

 

i forgot how to aggregate data from a table without using data of the filtering dimension or creating a link.

 

indeed, I have a data schema “orders” with a list of orders ( order date, order id, customer id, item, price) and i want to transform (pivot) that table at customer id in order to have the number of items ordered per customer) : I do not want to use the method by going first to the “customer” data shema in the query and adding data 

 

Thanks in advance for your answers,

Terry