Hi Techies,
I have below requirement regarding Drill down Group.
I have 4 dimensions as shown in below table.
| Area | Company | Region | Branch |
|---|
| R01 | Atum(00470) | Bergen | Bergen |
| R01 | Atum(00470) | Bodo | Bodo |
| R01 | Atum(00470) | Hamer | Hamer |
| R01 | Atum(00470) | Harstad | Harstad |
| R01 | Atum(00470) | Larvik | Larvik |
| R01 | Atum(00470) | Moss | Moss |
| R01 | Atum(00470) | Oslo | Oslo |
| R01 | Atum(00470) | Staranger | Staranger |
The expression is: sum({<[CATEGORYCODE]={'TR'}>[Amount]})
---> Area and Company has only one value
---> Region and Branch has similar values
I tried to create a drill down group on bar chart with the order as Area,Company,Region,Branch.
But the chart is showing Region at first level and next Branch. I am unable to display Are and Company.
Can anybody help me regarding this issue?
Thanks,
Rajasekhar
