Query to Display Data in Hana Version

[ramco1917]

Hi

  I want to display data like below without Pivot. Locations can be more. How it can be done without using Pivot

		Location 1	Location 2	Location 3	Location 4
Item1	Event1	10		20
Item2	Event2		30		10

Thanks