Hi experts
I need create a Bex query with the data and format like the table below. I created the query in query design execept the column of Keyfigure01.
Cause I have no idea how to put this kind of key figure column into it. I would appreciate you give some hits on this point.
Thanks in advance.
Characteristic01 Characteristic02 Keyfigure01 Keyfigure02 A1 B1 Average of K1,K2,K3 based on A1 K1 B2 K2 B3 K3 A2 B11 Average of K11,K12 based on A2 K11 B12 K12