Pivot Table

[tyagishaila]

Hi,

I am new in qlikview. Please Help me out to get the value of partial sum in pivot table.

I need those values in my expression calculation.

Thanks

[mato32188]

Hi Shaila,

in Presentation tab is check box Show Partial Sums... use it on level, you need to show values.

BR

M

[#3]

Hi

first create an expression sum(yourdesiredfield) and in the presentation tab enable show partial sum option for this expresion.

it will reflect in the chart

[anbu1984]

Check this link

https://www.youtube.com/watch?v=txgHKIoPQRM

[prma7799]

Hi,

click right click on pivot table > presentation > tick show partial sum.

Thanks

[tyagishaila]

Yes I know about option of partial sum,

but I need this value in my Expression calculation.

I want to know how can I take this value, i.e. expression for partial sum

[SunilChauhan]

sum(Total<dimensionfield>amount)

[prma7799]

sum(Total<CalendarYear>[Total Sale Amount])

[tyagishaila]

Thank You Anbu

But My requirement is little bit different. I want to use the value in my

next expression which comes after partial sum.

I want to find %.

Shaila

On Wed, Dec 10, 2014 at 7:44 PM, anbu cheliyan <qcwebmaster@qlikview.com>