OTBI Analysis - collapsible/expandable rows

Content

Hello Team,

I have requirement to prepare analysis with collapsible/expandable rows (similar like in hierarchical column).

Bisuness case i have

Owner---------------------------------Q1 Revenue Total | Q2 Revenue Total | Q3 Revenue Total | Q14Revenue Total

Customer--------------------Q1 Revenue Total | Q2 Revenue Total | Q3 Revenue Total | Q14Revenue Total

Opportunity--------Q1 Revenue Total | Q2 Revenue Total | Q3 Revenue Total | Q14Revenue Total

 

This is a simple to achieve by pivot table but how to make Owner,Customer,Opportunity collapsible ?

Any comment is this is a possible in OTBI when columns are not hierarchical in subject area ?

 

Regards,

Marcin