jonespandrew
New member
- Joined
- Jan 27, 2016
- Messages
- 122
- Reaction score
- 0
- Points
- 0
Hi I am trying to create a dashboard in excell based on one sheet of data what is attached is what I have come up with so far on the sheets labled Reactive SUM1 Reactive sum2 ppm sum I am trying to get it so when the open up the one sheet they get an overal view of the region, then they select there site and they see the data from there site similar to what i have got now. are there any step by step guides on how to do this.
Also trying to create a calculated field in pivot table to calulate the pass%
Kind regards
Also trying to create a calculated field in pivot table to calulate the pass%
Kind regards