Total in different place

[Anonymous]

Hello,

¿Is is possible to have the pivot table total for example on the middle?

Thank you

[niclaz79]

Hi,

Not sure exactly what your use case would be, but total can only be on the top or bottom. However you may have totals on each hierarchy level on the pivot, by clicking in 'Partial Sums' in the 'Presentation' tab.

[sunny_talwar]

Can be programmed in a different way, can you share a sample?

[Peter_Cammaert]

Are you trying to create a P&L-like layout in your pivot table?

[Anonymous]

for example:

segment	value
segment1	2
segment2	4
total	12
segment3	6

[Peter_Cammaert]

You may put subtotals and aggregations of any kind wherever you like. But it means some additional work is to be performed, as QV isn't capable of doing this on its own.

See here for an example of P&L layouts: How IntervalMatch Solved My Profit and Loss Dilemma

[fkeuroglian]

Pablo how are you?

Not posible to create this in the same table, could you create in two different tables and using disegn create as like one

Hope help.

Fernando K.