Im working on a project for my internship and need some help from you guys.
I got all my data for my reports set up in a format of
Months - - - - - - - -
Years
-
-
-
-
Im trying to set up a pivot table for each report and then merge them together to make a income statement performance dashboard. I want to then format it so that I have a slicer with the years. Im find it hard to do this because I want the slicer to control the years for all the report to make it easiler. Also how do you merge data in pivot tables? I tried data consolidation but its not working good with the pivot tables for me. Looking for a direction to my huge problem in my project..Thanks!!
I got all my data for my reports set up in a format of
Months - - - - - - - -
Years
-
-
-
-
Im trying to set up a pivot table for each report and then merge them together to make a income statement performance dashboard. I want to then format it so that I have a slicer with the years. Im find it hard to do this because I want the slicer to control the years for all the report to make it easiler. Also how do you merge data in pivot tables? I tried data consolidation but its not working good with the pivot tables for me. Looking for a direction to my huge problem in my project..Thanks!!
