I need excel Expert
Budget: £5 – £10 GBP
Hi Team,
I'm looking to wrap sum with getpivotdata from a pivot table, so when i link the figures for April from the pivot table , I also want to link May from the pivot table with getpivotdata and sum both April and May and arrive at ytd actuals. please review my file and advise. I was using this formular but it not working=SUM(GETPIVOTDATA(""&$R3:AA3,$Q$3,"Month Value",$Q$4:$Q$6
Please review and advise
thanks
I'm looking to wrap sum with getpivotdata from a pivot table, so when i link the figures for April from the pivot table , I also want to link May from the pivot table with getpivotdata and sum both April and May and arrive at ytd actuals. please review my file and advise. I was using this formular but it not working=SUM(GETPIVOTDATA(""&$R3:AA3,$Q$3,"Month Value",$Q$4:$Q$6
Please review and advise
thanks