Forum Discussion
Switch headers in dynamic matrix built with calculation groups
You may want to consider using field parameters instead of calculation groups.
As for the crazy column hierarchy - that requires a disconnected table and a crossjoin to fakely convert the measures into columns.
Hi Ibendlin,
My mistake in the wording, the measure (Sales figures and Market Share) are done via paramneters and the time intelligence via Calculation groups, to save time and to not have 130 combinations of measures bulk up the file size. Do you think that with this combination of 1 parameter and one calculation group it is still possible to have the disconected table and crossjoin option and if so do you have some article on this subject that I can read on and try implementing the suggested sollution?
Thank you again in advance!
No, i don't think that can be done in a sustainable fashion. Push back on the user requirement. Your implementation is already complex enough.