OBIEE Analysis - snake presentation

Robert Angel

Hi,

I have a pivot table in OBIEE where the client wants the presentation to break on quarters, with the months appearing as columns, thus

Quarter 1

                      

                  Jan  Feb Mar

                  other columns      

rows various

Quarter 2

                      

                  Apr  May Jun

                  other columns      

rows various

Quarter 3

                      

                  Jul  Aug Sep

                  other columns      

rows various

Sure you get the idea...

Is there anyway to achieve this _AS A SINGLE ANALYSIS_, because when I put the quarter in columns, I get all twelve months in the columns, which is not my desired effect

thanks,

Robert.

Andrew Fomin.

Do you want something like this?

Robert Angel

Yes, exactly that - how is this done?

many thanks for your input,

Robert.

Andrew Fomin.

Pivot table layout

Robert Angel

Embarrassed not to have seen that before / found it - excellent - thank you!!!