I have 2 Pivot table one is display yearly sales , another is display yearmonth sales.
I like to combine both 2 pivot table into 1.
Can some one advise me how to do it ?
if this is achieve , i can view YTD sales vs monthly sales for particular year, Yet i don;t need to manually create 12 expression, which is not productive.