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):
Tagged:
0