on 06-02-2014 6:44 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.