I was trying to perform row level calculation on these dimension like china , india, Japan
My Variable Contain ---- sum([Unit Cost])/(sum(Units))---
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)
i want to show these ACtual , Budget , Last year Calculation in Percentage for the particular Account Code..
not clear, can you elaborate more your problem?
Retrieving data ...