Hi,
I have a pivot table like below
<tbody>
</tbody>
I am wanting to to sum all the values from 201509 to 201550 for March.
How would I go about doing that with Sumproducts?
A single get pivot looks like
=GETPIVOTDATA(GETPIVOTDATA("[Measures].[Sum of InsertNetCost]",$B$5,"[CalendarNew].[Fin Year]","[CalendarNew].[Fin Year].&[2017]","[category].[category]","[category].[category].&[Agriculture / Pets]","[adTrans].[FinWeek Number]","[adTrans].[FinWeek Number].&[2.01603E5]")
Thanks for help
I have a pivot table like below
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | |||||||||
<tbody> </tbody> | ||||||||||||||||
<tbody> </tbody> | ||||||||||||||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | 11 | |||||||||||||
<tbody> </tbody> |
<tbody> </tbody> | |||||||||||||||
<tbody> </tbody> | 10.23 | 10.23 | 10.23 | 10.23 | 10.23 |
<tbody>
</tbody>
I am wanting to to sum all the values from 201509 to 201550 for March.
How would I go about doing that with Sumproducts?
A single get pivot looks like
=GETPIVOTDATA(GETPIVOTDATA("[Measures].[Sum of InsertNetCost]",$B$5,"[CalendarNew].[Fin Year]","[CalendarNew].[Fin Year].&[2017]","[category].[category]","[category].[category].&[Agriculture / Pets]","[adTrans].[FinWeek Number]","[adTrans].[FinWeek Number].&[2.01603E5]")
Thanks for help