Interchange row and Columns using Secondary dimensionality function in Pivot table

Lakshman_1031 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have one pivot table in that i am using Adhoc with Multiple dimensions.

I have used Secondary dimensionality in Expression.

Without interchange the row and columns data is perfectly matching but when if i interchange the row and columns then data is miss match.

I want to interchange the rows and columns without effect the data.

If possible please suggest me without using Secondary Dimensionality function how to achieve the same scenario without effecting the data.

Please see below attached Qvw for reference.

Thanks & Regards,

Lakshman

topic Interchange row and Columns using Secondary dimensionality function in Pivot table in QlikView