I have 6 dimensions and 3 expressions in my pivot table. Whichever dimensions or metrics user selects,only those will get displayed in pivot table.And i want view of table to be pivot up.
One of dimension is Months which is always selected. Now all my dimensions which are selected are coming in pivoted up view. But for expressions, if only one metric is selected then month and metric are coming are seperate columns. If more than 1 metric is selected then metrics are coming month wise where individual months are my columns which is correct pivot up view.
Does anyone know how to get correct pivot up view for single metric too?