Is it possible to show Filtered Total and Unfiltered Total in Pivot/Straight Table?

[#1]

Hi ,

I want two totals in Pivot/Straight Table . One is filtered and other is unfiltered.

Just like:

[jagan]

Hi,

I think it is not possible, but we can do this by using two Pivot tables. 

Please check the attached file for solution.  I used separate table for Total. 

Hope this helps you.

Regards,

Jagan.

[#3]

Thabks for reply.

Yes, I already done this by using two tables.

1st one is showing filtered and other is unfiltered by using sets.

But i want Both totlas in One table only.

[jagan]

Hi Sandeep,

I think it is not possible in a single chart.  The Total and values are displayed in the chart based on single expression.  There is no option for specifying the Total expression separately.  I think you understand this limitation in qlikview.

Regards,

Jagan.