ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   calculated members - OLAP pivots (https://www.excelbanter.com/excel-discussion-misc-queries/88600-calculated-members-olap-pivots.html)

claudiaormond

calculated members - OLAP pivots
 

Hi there,

I have a OLAP pivot in excel and I need to add a calculated field to
it. The thing with OLAP pivots is that you have to add calculated
member in VBA, you cant just go through the usual menu options.

I need to use an IF function based on 2 other fields in this calculated
member. I honestly wouldnt even know where to start with the code to add
it in.

Can anyone please help?

Thx


--
claudiaormond
------------------------------------------------------------------------
claudiaormond's Profile: http://www.excelforum.com/member.php...o&userid=34447
View this thread: http://www.excelforum.com/showthread...hreadid=542065



All times are GMT +1. The time now is 05:28 PM.

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