I am making a bar chart that shows the sum of sales by certain stages (i.e. stage 1, stage 2, stage 3).
Each stage can be broken down into steps (i.e. 1.1, 1.2, 1.3). So I have a drill-down group as my dimension using the Stage, and sub-Stage fields.
I am also trying to do comparative analysis within my chart. So I have two expressions: one expression for alternate state 'One'. And another for alternate state 'Two'. These alternate states each have list boxes associated with them that allow the user to select different years and months to do comparisons.
My issue is now that I have included alternate states into my chart, my drill-down group no longer works like it did before.
When selecting Stage 1, it shows all substages (1.1, 1.2, 1.3, 2.1, 2.2, 2.3 etc. etc).
Can anyone explain this?
