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 😔