Hi – appreciate some help as continue to learn about pivot tables and their uses. Attached is a sample workbook to illustrate current problem.
How can I calculate the exceedance value for a column of data (% Grand Total from pivot table6) so for a given threshold limit value of say 2m the exceedance above this value is automatically computed (and associated plot updated) when I refresh the pivot table i.e red highlighted cells dynamically update with pivot table.
Is there any way I can amend the sheet/workbook so able to input a specific limit value eg 2.5m and determine the % value of exceedance above this value for all recorded data points? My attempt to do this is just by manually selecting computed results that are over the specified threshold limit but this is not a true accurate account of the results and cumbersome – see also on tables sheet countifs calc which I believe more accurately calculates exceedance above a specified value. Can this calculation and or above issue be incorporated into the source table so able to include in pivot table somehow?
Lastly and minor point but why is there a slight variance in the computed grand total % values in pivottable6 and 7 eg 22.90% vs 22.66%. It appears this is maybe due to fact one table shows values as % of column total and other % of grand total but unclear how arrived at.