convert straight to pivot table

[paulwalker]

Hi Community,

I Have straight table, 2 dimensions and 5 expressions.

is there any possibility, 1st 3 expressions under Actual and rest under Budget.. like pivot table (any possibility in manual way?)

Like this?

PFA,

[paulwalker]

Did anyone face above requirement ?

[jyothish8807]

Hi Paul,

May be something like this: pls refer the attached

Br,

KC

[Sergey_Shuklin]

Hello!

Straight table have few stricts. One of them is ordinal defined position of dimensions (all). They can be placed vertical or horizontal. You can't mix it (some vertical and one horizontal for expressions). For such tasks exists pivot table.

So if you stricly managed for using only straight table, then the only way is to use textboxes.