When pivoting, select which items to show for each dimension

Options
victorceneviva
victorceneviva Member, ALL USERS, Community Member Posts: 3 New Contributor

Hi,

 

We have some modules where with multiple dimensions, for instance: Time, Version, Line Items.

 

When pivoting for some analysis and adjustment, we would like to have Time and Version as Columns and Line Items as rows. However, when doing that, we are unable to select specific items for the columns, for instance, 2 or 3 years for time and 2 specific Versions.

 

Is there a workaround that could enable it? With our previous EPM system, we could select specific items for each dimension.

 

Thanks,

Victor

Tagged:

Comments

  • victorceneviva
    victorceneviva Member, ALL USERS, Community Member Posts: 3 New Contributor

    Hi David,

     

    This solution solves our problem, as we need it for specific reports. We are implementing for some of our modules.

     

    Thanks!

     

    Victor