Hi,
I am creating an interactive report using the pivot tables.
The report presents a lot of data then uses pre made medians against the
averages and std in the pivot tables to color code any possibly flawed data before reducing the pivot tables to just averages.
After user will have abiltiy to drill down to data and mark a record d or u in the drill down. this will then take the data out of the analysis andinto a dump sheet, and the pivot tables are recalulated.
Because I want all the data eliminated to go to the dump sheet so next time I retrieve data from the system I can then eliminate proior dumps I want to keep the data sheet hidden. Does hidding data sheet cause pivot tables any problems?
I am creating an interactive report using the pivot tables.
The report presents a lot of data then uses pre made medians against the
averages and std in the pivot tables to color code any possibly flawed data before reducing the pivot tables to just averages.
After user will have abiltiy to drill down to data and mark a record d or u in the drill down. this will then take the data out of the analysis andinto a dump sheet, and the pivot tables are recalulated.
Because I want all the data eliminated to go to the dump sheet so next time I retrieve data from the system I can then eliminate proior dumps I want to keep the data sheet hidden. Does hidding data sheet cause pivot tables any problems?
