Split top level dimension (drill down group) into 2 other dimensions?

[#1]

Hi,

I have the following drill down group:

company
invoice_number
invoice_date

With this drill down group I have to click twice to see invoice_number or invoice_date. Is it possible to change the drill down group to

company
invoice_number invoice_date

so I will see invoice_number and invoice_date in two separate columns in the straight table at the same level after clicking on top level company? Or is there another solution for this functionality (split a dimension into 2 other dimensions)?

Looking forward to your suggestions.

Claudia

[pover · Accepted solution]

Is it possible to change the straight table to a pivot table with the 3 dimensions mentioned?

Regards.

[#3]

Karl,

Thanks for your suggestion. The 'Expand all' option on top level dimension (company) will do the trick .

Regards,

Claudia