I have a stacked bar graph for revenue by quarter, stacked by territory, but how do I add percentages to each territory??
I have tried everything trying to create this image and checked on the discussion boards and I am completely lost!!!
We have a sales dashboard for part of our company, it has $ value of revenue on the lefthand side, and each quarter along the bottom.
We have a stacked bar chart for each of the 5 territorys - AP, EU, GC, JP, NA
I need to be able to show the % amount of revenue by quarter for each region. i.e. if you look at the chart you could see for 3Q 2012, EU made up 25% of the revenue for the quarter, AP was 20%, GC was 20%, JP was 15%, and NA was 20%
See attached image of the dashboard as it is right now.
Our dashboard drills down on a certain BU, or end market segment, so the labels need to be able to flow if someone drills down for Buiness Unit A, the labels should change
your else statement could be a grouping of all of your years or anything else, if that value doesn't exist in your year dimension, i'd create an inline table for year 2004 through 2011 and a Combined YTD field. Then use this instead of your Year dimension.
Now you could plot your line using the same logic with an if expression. I'd be careful using an IF statement like this in an extremely large data set as QV isn't great at performing if statements.