Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to create a Cross-Tab reporting using BIP Excel Template

Summary:

How to create a Cross-Tab reporting using BIP Excel Template

Content (required):

Hi,

We have a complex report layout and we have to develop it using BIP Excel Template.

The data should be presented in Cross-Tab layout. We have tried to get the raw data in a sheet and use the standard Excel Pivot Table to present the data but it not giving the desired results.

Is there a way to define the Matrix/Cross-Tab logic similar to Word Template? If not, is there any creative way to do it?

Note: the data in the matrix

Version (include the version you are using, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!