I'm working on a stacked chart displaying yearly revenue data.
So each bar represents the total revenue for a given year and is stacked/built from the revenues of composite businesses in that year. Within the graph, I want to calculate the year-on-year percentage change in total revenues.
However, because the data is multidimensional, with "Year" being the larger dimension, the "above()" command doesn't work - instead it calculates the percentage difference between businesses.
Is there a way to construct the code so that qlikview overrides (or ignores) the business dimension for the purposes of this calculation only, or should I investigate changes in the expression I am using?