can crosstab show multiple objects in top header?
for example, the data showed as :
customer city name city value product name product value A Paris 1 food N A London 2 milk T B London 3 food E B Paris 4 milk M C London 6 food W C Paris 3 milk Q D London 1 food E D Paris 2 milk R
i want show these data in crosstab, and customer is the left header, city name and product name are the top header, and city value and product value are measures in the crosstab,
and i want show the data as below:
London Paris food milk A 2 1 N T B 3 4 E M C 6 3 W Q D 1 2 E R
but actually i got below result in crosstab:
London food London milk Paris food Paris milk A 2 T 1 N B 3 E 4 M C 6 W 3 Q D 1 E 2 R
anyone can help me on this?