soma06_bhat
New Member
- Joined
- Aug 16, 2016
- Messages
- 1
I am using below formula to fetch data which in a different tab in pivot and paste that in another tab.
Now the problem is I am getting a #ref message while using this formula,
=getpivotdata("[Measures].[cancel]'.pivot!$c13,"[month]','[month].
[month].&[2016-04-30]',[characteristics].[primary]',
[characteristics].primary&[$c$12]",
[characteristics].[secondary]",&[$c$22]"
when I am using the direct data of cell no c22 and c13 its working but I want to use the cell reference for both these cells and also wondering if I Can map the date automatically using formula so that leapyear days are calculated automatically instead of specifying it month wise as I did above in the formula.
Please let me know your suggestions. Thank you!!
Now the problem is I am getting a #ref message while using this formula,
=getpivotdata("[Measures].[cancel]'.pivot!$c13,"[month]','[month].
[month].&[2016-04-30]',[characteristics].[primary]',
[characteristics].primary&[$c$12]",
[characteristics].[secondary]",&[$c$22]"
when I am using the direct data of cell no c22 and c13 its working but I want to use the cell reference for both these cells and also wondering if I Can map the date automatically using formula so that leapyear days are calculated automatically instead of specifying it month wise as I did above in the formula.
Please let me know your suggestions. Thank you!!
