LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Azad Thalor

Are there any reporting features like cross tab, Pivot table present in Lavastorm? Please suggest.

Thanks and regards,
Azad Thalor
India

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: stonysmith

Under "Metadata and Structure" are a pair of nodes called "Pivot Data to Names" and "Pivot Names to Data".
The first of these two nodes is almost equivalent to an Excel Pivot table - the second node is to "undo" that type of operation.

The major difference between "Pivot Data to Names" is that Excel will aggregate multiple values into a single cell of the pivot table.
With LAE, you need to use the AGG node first to produce only one value per cell.. then use "Pivot Data to Names" to reshape the data.