ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to make my own formula for OLAP Pivot table? (https://www.excelbanter.com/excel-discussion-misc-queries/72693-how-make-my-own-formula-olap-pivot-table.html)

Abobakr Nasr

How to make my own formula for OLAP Pivot table?
 
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.



All times are GMT +1. The time now is 07:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com