basic help for formulas

[#1]

Hi,

For one of my crosstab I want to have a column like show the growth for a particular dimension, growth is precalulated in my data source sheet.

In short kind of where clause want to utilize like " growth where P = AT i tried to use if expression as -- If (P ='AT',Sum(growth) but dont think it is working it shows me the growth infront of that Dim only but i dont want to put that as column into my cross tab i need two exp. one is that i mentioned and second is the total growth with that where clause.

output cross tab like below -

Country Name	APP	Growth	Calendar Year 2009	Calendar Year 2010	Calendar Year 2011	Calendar Year 2012	Calendar Year 2013
Australia	A	AT' Growth		- %	- %	- %	- %
		Total Growth		- %	- %	- %	- %

Source table is something like that --

Country	Year	APP	P	Rev	Growth
Brazil	2009	AE	AD	50	0
Brazil	2009	AE	AT	60	0
Brazil	2009	BL	M	11	0
Brazil	2009	BL	AR	44	0
Brazil	2010	AE	AD	50	0.045717
Brazil	2010	BL	AT	65	0.085709
Brazil	2010	AE	AD	49	0.04
Brazil	2010	AE	AT	60	0.0654
Brazil	2010	BL	M	10	0.235
Brazil	2010	BL	AR	45	0.235
Brazil	2010	AE	AD	70	0.045717
Brazil	2010	BL	AT	80	0.085709

<multiple countries there in source>

So for outpt first we need growth for AT only and in the next we need overall growth, kindly shed some light.

growth is calculated keeping base year as 2009 and based on Rev.

[#2]

tRY THIS

If (P ='AT',Sum(TOTAL growth)

[#3]

thanks for the reply ..

bt so sorry did not get this..could you please eloborate and also the structure is the problem how could i arrange this cross tab as with one expression i can.

[#4]

is this what you want? (Blue table)

[#5]

Thanks Jochem for efforts.

yes structure would be something like that or i can manage accordingly(exact have pasted below)

would you please eloborate on formulas so I can check with actual data.. sry but m not dig dipper in QV reporting.

Country	App	Growth	Year 2009	Year 2010	Year 2011
Brazil	AE	AT growth		%	%
		Total Growth		%	%

[#6]

some help pls.

[suniljain]

you have to implement it in script level otherwise in desin level its take too much time for calculation.