topic Re: How to perform row level Calculation in Pivot table...? in QlikView

How to perform row level Calculation in Pivot table...?

sgg_gaikwad — Wed, 27 Aug 2014 08:54:05 GMT

I was trying to perform row level calculation on these dimension like china , india, Japan

=IF(CountryName='China',$(vchina), CountryName)

My Variable Contain ---- sum([Unit Cost])/(sum(Units))---

amit_saini — Wed, 27 Aug 2014 09:01:34 GMT

Swapnil,

Do you mean something like that below: (Suppose I'm doing w.r.t row number 25 in my pivot table)

=IF(not isnull(BalancePosition) and rowno <> 25 and Type = vSpalte3,BalancePosition)

Thanks,
AS

maleksafa — Wed, 27 Aug 2014 09:02:08 GMT

not clear, can you elaborate more your problem?

sgg_gaikwad — Wed, 27 Aug 2014 09:09:42 GMT

i want to show these ACtual , Budget , Last year Calculation in Percentage for the particular Account Code..