Skip to Content
Former Member
Jul 23, 2013 at 11:05 AM

Aggregation in Dashboards



I get back from my query (universe) the objects: customer, year, amount. So for each customer I get multiple rows for each year one with an amount.

I am used to WebI, where the values get aggregated automatically. But in Dashboards I get several lines for each customer in my excel sheet, which is a problem when i want to display the result in a graph.

I need the year, because I would like to use it as a filter for what-if analysis (slider component) in my dashboard.

How can i do that? Is an excel pivot table a soluition? I tried it but didn't give me any data 😔