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

    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 NameAPPGrowthCalendar Year 2009Calendar Year 2010Calendar Year 2011Calendar Year 2012Calendar Year 2013
      AustraliaAAT' Growth- %- %- %- %
      Total Growth- %- %- %- %


      Source table is something like that --

       

       

      CountryYearAPPPRevGrowth
      Brazil2009AEAD500
      Brazil2009AEAT600
      Brazil2009BLM110
      Brazil2009BLAR440
      Brazil2010AEAD500.045717
      Brazil2010BLAT650.085709
      Brazil2010AEAD490.04
      Brazil2010AEAT600.0654
      Brazil2010BLM100.235
      Brazil2010BLAR450.235
      Brazil2010AEAD700.045717
      Brazil2010BLAT800.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.