Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
How can i create my own formula in a PivotTable or PivotChart report that depends on an OLAP data source. This option is available for pivottables from other data sources as 'Calculated Item' and 'Calculated Field', not available for pivot table OLAP data source. I need to evaluate a year-to-year growth rate for a year seris include 12 years, my function is [(X2/X1) -1] *100 where X2 is the value of current year, X1 is the value of previous one. Any sugessions will be appreciated. Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using a MODE formula in a Pivot Table | Excel Worksheet Functions | |||
How do I add a formula to activate a pivot table list?? | Excel Discussion (Misc queries) | |||
Pivot Table Formula | Excel Discussion (Misc queries) | |||
pivot table created from another pivot table | Excel Worksheet Functions | |||
how do I make hard carriage return appear in pivot table? | Excel Discussion (Misc queries) |