Pivot Table Format

[Upali_Wijearatne]

I have below Pivot table in my QV document (Table 1) Pls .  I want to format it as shown (table 2) and I am unable to do it. In other words I want to f1st two columns to be inserted before the salary details column of each employee. Pls help me to achieve it.

[marcus_sommer]

It's not possible. You may create n specialized objects side by side to get such view ...

[Upali_Wijearatne]

Thanks.

Pls advise me how to do it

[marcus_sommer · Accepted solution]

Add a condition in your expression like: sum({< Name = {'X'}>} Value) and the copy & paste the object n times and adjusting in each copy the condition from X to Y to Z and so on.