cancel
Showing results for 
Search instead for 
Did you mean: 

Pivot Table functionality

uwe_kohlmann
Explorer
0 Kudos


Hi guys,

I am looking for a way to create tables like in SAS' proc tabulate, SPSS Tables or Excel Pivot Table (actually the Power Pivot functionality which allows to do distinct counts, too).

I am sure Lumira is able to something like that, but I didn't find it yet.

Cheers,

Uwe

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Closest i've seen to this is to create a Table visualization, and change aggregation for the measures / create new calculated measures for your specific needs.

You won't have a drill down per se, only by adding and removing dimensions in the visualization mode you can simulate this, but then, you won't be able to do it in a story panel. A (somewhat) limited possibility is to have multiple tables/panels in the story, each one on a different drill-down level, and navigate accordingly.

- Antero

Answers (1)

Answers (1)

Former Member
0 Kudos

I might be resurrecting an old thread, but, just found out this on Lumira 1.17:

Upon connecting to a BEx query, if your query has any infoobject with hierarchies, those same hierarchies will (upon enabling them), let you do a drill down in Lumira on a table visualization:

This is a lot closer to how an excel pivtot table works.

- Antero