Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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))---
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
not clear, can you elaborate more your problem?
i want to show these ACtual , Budget , Last year Calculation in Percentage for the particular Account Code..