Hi,
i am looking for a solution , where i have 2 sheets of data and i want to create single pivot table...2 sheets data is same except month....first sheet is till jan to oct and 2nd sheet is for nov
i know there is option to consolidate sheets in pivot table and i am able to create it but i need mutiple option to be in filter category in pivot, which i am not able to do...
untill now i have created pivot table (sheet attached) but i want Area,category and region in filters and common name in rows , count of ACT1 in values and month in columns.
Any suggestion appreciated.
Thanks
i am looking for a solution , where i have 2 sheets of data and i want to create single pivot table...2 sheets data is same except month....first sheet is till jan to oct and 2nd sheet is for nov
i know there is option to consolidate sheets in pivot table and i am able to create it but i need mutiple option to be in filter category in pivot, which i am not able to do...
untill now i have created pivot table (sheet attached) but i want Area,category and region in filters and common name in rows , count of ACT1 in values and month in columns.
Any suggestion appreciated.
Thanks