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 can I make columns not visible without hiding them?

Accepted answer

I'm trying to build a report that will be both viewable through a web browser and exportable to Excel as an ad-hoc. I have years, scenarios, and versions in columns; entities and products - in the rows. Other dimensions are in POV.

There are three types of rows in the report:

Col A | Col B | Col C

Entity | Product | MemberAlias(Entity). |

Entity | Product | MemberAlias(Product). |

Entity | Product | Some text |

Column A and B are the standard member columns, column C is a text column. Dots after MemberAlias are needed so after the export to Excel I wouldn't have conflicting entities or products in two columns.

Howdy, Stranger!

Log In

To view full details, sign in.


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