1 Reply Latest reply: Jun 23, 2014 2:26 PM by whiteline _ RSS

    Bar Chart - Budget and Actual as Grouped - Sliced by Quarter

    Nathaniel Anderson

      Is this possible? (In my opinion it's not very useful since the budget amounts are stacked; not 0-based (except for Q1); i.e. hard to compare Q2 to Q2. But it's what the client wants)

       

      • Two dimensions (Division ('North', 'South'), and Quarter ('Q1', 'Q2', 'Q3', 'Q4')
        • First-level group the Division dimension
        • Stack the quarter slices
      • Two expressions (SUM(Budget), SUM(Actual));
        • Second-level Group these two expressions

      Bar Chart - Budget and Actual as Grouped - Sliced by Quarter - Google Drawings

      Bar Chart - Budget and Actual as Grouped - Sliced by Quarter.jpg