5 Replies Latest reply: Dec 13, 2011 6:19 AM by 905015 RSS

    Column drilldown in a pivot table

    713519
      Hi, 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!