Add a new line for a custom total

[Anonymous]

I need to create the following table in qlikview

I have a filter comp

How could I add a custom total above total with the same expression but with the condition of comp = O?

[Anonymous]

maybe,

you'll need to create

another dimension that group the two levels

like in this post.

Sub total issue in Pivot table

[Chanty4u]

hi,

Custom Total or Conditional Total Column

https://community.qlik.com/message/849780#849780

https://community.qlik.com/message/740466#740466

the above wil helps u

Thanks

suresh

[vikasmahajan]

PFA SAMPLE

Hope this helps you.

Vikas

[Anonymous]

like this?

Custom total calculation in Pivot table

Custom Labels in Pivot Table

[tyagishaila]

Try it,

Concatenate a TAB with your original Table

OriginalTAB;

Concatenate

NEWTAB:

LOAD 'Dept Total' AS DEPARTMENT,

put your fields

Resident OriginalTAB where Comp = O;

It will show a custom 'Dept Total' row in Department column.