Want to show table with dimensions as values from other table

[#1]

how to create a table in this structure

table1:

   col1    col2    col3

A   a1     a2       a3

B   b1     b2       b3

C   c1     c2        c3

actually i want this table

                   a3                        b3                   c3

    a1       calculation            calculation         calculation

    b1       calculation            calculation         calculation

    c1       calculation            calculation         calculation

[Gysbert_Wassenaar · Accepted solution]

Create a pivot table with col1 and col3 as dimensions. Drag col3 to the right above the expression(s) so it gets pivoted to horizontal layout.

[saumyashah90]

Check this

[#4]

thanks i got the reasult

[#5]

if i want selected fields like

                      a3                                     c3

    a1            calculation                    calculation

     c1          calculation                     calculation

actual table is the same as i have asked previously.

[#6]

if i want selected fields like

                      a3                                     c3

    a1            calculation                    calculation

     c1          calculation                     calculation

actual table is the same as i have asked previously.

Want to show table with dimensions as values from other table

[saumyashah90]

take col1 and col3 in dimension and in expression give some calculation

after tha drag col3  above calculation