siemensslave
New Member
- Joined
- Sep 10, 2004
- Messages
- 23
Hi,
I have a pivot table that references a SharePoint list. In the sharepoint list, there are checkboxes which export to Excel as TRUE or FALSE depending on whether they are checked or not.
For a given pivot table column, I am trying to calculate the % of the data total that are displayed as TRUE. Ive looked under count - advanced options and cant seem to get it.
Heres a sample of the data:
Name Location Business Segment Basic Training Risk Management Training PM4 Training
Ratzki, Markus Mülheim Mods & Upgrades TRUE FALSE TRUE
Schmidt, Kai Mülheim Mods & Upgrades FALSE FALSE TRUE
Winkler, Andreas Mülheim Mods & Upgrades TRUE FALSE TRUE
Rialland, Nicolas Mülheim Mods & Upgrades TRUE FALSE TRUE
Gluschkowskij, Igor Mülheim Mods & Upgrades FALSE FALSE FALSE
Any ideas are much appreciated!!
Thanks,
Matt
I have a pivot table that references a SharePoint list. In the sharepoint list, there are checkboxes which export to Excel as TRUE or FALSE depending on whether they are checked or not.
For a given pivot table column, I am trying to calculate the % of the data total that are displayed as TRUE. Ive looked under count - advanced options and cant seem to get it.
Heres a sample of the data:
Name Location Business Segment Basic Training Risk Management Training PM4 Training
Ratzki, Markus Mülheim Mods & Upgrades TRUE FALSE TRUE
Schmidt, Kai Mülheim Mods & Upgrades FALSE FALSE TRUE
Winkler, Andreas Mülheim Mods & Upgrades TRUE FALSE TRUE
Rialland, Nicolas Mülheim Mods & Upgrades TRUE FALSE TRUE
Gluschkowskij, Igor Mülheim Mods & Upgrades FALSE FALSE FALSE
Any ideas are much appreciated!!
Thanks,
Matt