FYI: Starting in 4.2 SP3 the ability to reference cells in WebI like you can in excel was added. That should do what you are looking for once you are able to upgrade.
https://archive.sap.com/documents/docs/DOC-74364
Check under the References section.
You have to start using variables instead of directly using formula.
e.g.
Var1=[Value]Where([period]='First'and[Month]='M1')
Var2=[Value] Where ([period] = 'Second' and [Month] = 'M')
Var3=[Value] Where ([period] = 'Third' and [Month] = 'M1')
Your sum formula will be simple like =sum([Var1]+[Var2]+[Var3])
Group function you can find under the analysis tab.
Add comment