Hello,
I have a chart which has a group as a dimension. The group contains four fields.
I am using macros to export it to Excel but the only field exported is the one which is selected on the group and the values, this is good.
Is there any way using macros to export all the fields onf the group with the values, regardless which field of the group is selected?
I am looking for someting like the following table exported to Excel:
Field 1 | Field 2 | Field 3 | Field 4 | Value 1 |
---|
Region | Country | State | City | 100 |
Of course the group contains Field 1 to 4
Thank you