I have created a macro (using Python) to create a crosstab table (report object) with multi-level attributes on the columns and/or rows as well as multiple metrics. What I am struggling with is how to create the configuration options that will do two things:
1. If the user selects a dataset column for presentation on the rows, i want it to unselect the dataset columns that is selected for the rows (mutually exclusive). How would I go about implementing that action.
2. When the user is selecting the metric(s), they can also choose the aggregation function. I was thinking of an interface like the summarize tool.
What is the best way to approach this? Anyone have something built that I can modify?
Thanks