Drill down Issue

PRS — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Drill down Issue

sunny_talwar — Thu, 13 Oct 2016 18:02:31 GMT

Try not to create multiple thread for the same issue. Look here:

Anonymous — Thu, 13 Oct 2016 18:24:14 GMT

Try this: