6 Replies Latest reply: Jan 3, 2011 8:29 AM by s j

# basic help for formulas

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.

• ###### basic help for formulas

tRY THIS

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

• ###### basic help for formulas

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.

• ###### basic help for formulas

is this what you want? (Blue table)

• ###### basic help for formulas

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 % %

• ###### basic help for formulas

some help pls.

• ###### basic help for formulas

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