How to make my own formula for OLAP Pivot table?

A

Abobakr Nasr

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

OLAP Pivot Table Calculations 4
Alternatives to MS Query for Pivot Tables & Cubes 0
Pivot Table Totals 0
Pivot Table refresh question 0
how to make my custom formula in OLAP data source pivot table? 0
How to convert OLAP data (PIVOT Table) to formula 0
Connection to Olap Cube 0
olap data cube 0

Top