topic Pivot Table Format in App Development

Pivot Table Format

Upali_Wijearatne — Wed, 31 Jan 2024 07:05:20 GMT

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.

Re: Pivot Table Format

marcus_sommer — Wed, 31 Jan 2024 12:39:12 GMT

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

Re: Pivot Table Format

Upali_Wijearatne — Wed, 31 Jan 2024 15:17:17 GMT

Thanks.

Pls advise me how to do it

Re: Pivot Table Format

marcus_sommer — Wed, 31 Jan 2024 15:34:41 GMT

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.