Column drilldown in a pivot table
713519Nov 25 2009 — edited Dec 13 2011Hi, I created 2 dimensions using BI Admin, with drillingdown option enabled at each level.
In Answers if I view them through a Table I can drill down clicking on a column title (for example State, click -> Region, click -> City, and so on...) but in my BI project I need to view the 2 dimensions one on rows and the other on columns, so I selected Pivot table.
But in pivot table I can't click on State column, only on the single cell value (for example USA), this is the only drilldown way I can do... is it normal? how could I drilldown clicking on columns?
thanks!