View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
claudiaormond
 
Posts: n/a
Default 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