Skip to Content
0
Former Member
Feb 03, 2015 at 10:47 AM

Reg:Reports

16 Views

HI,

I have a Butterfly Report .......like This



perodic YTD

2013.q2 2012.q2 THIS YEAR % LAST YEAR % ACCOUNTS 2013.Q2 2012.Q2 THIS YEAR % LAST YEAR %





WHEN I REFRESH THE SHEET ,PERODIC THIS YEAR % LAST YEAR % ARE NOT DISPLAYING BUT ,YTD THIS YEAR % LAST YEAR % ARE DISPLAYING..


NOTE: IN HIDING SHEET ....I USE EPM RETRIVE DATA FUNCTION..LIKE THIS FUNCTION IS =EPMRetrieveData(,$A434,$B$432,B$433,$I$425,A422)

BOTH PERODIC AND YTD HAVE SAME BUT CELL REFERENCE IS DIFFERENT.






SO PLZ GUIDE ME , TO RESOLVE THIS .





REGARDS

yESHWANTH

Attachments

Capture111.PNG (24.1 kB)