We are using a pivot table with more than 137 dimensions and few KPI. When we select a dimension and a KPI,
the column values change their position to rows. Please refer to the below screenshots.
With a single Metric:
With Multiple metric selected:
We can notice that the KPI which must be in the form of columns are now in row positions.
Did anyone notice this kind of Issue? I know more than 137 Dimensions is a huge number but is there any solution for this kind of scenario?