I have stacked two datasets (Alerts & Filings).
I have used the the chart functionality to pivot and colour code the data (attached).
How do I show a new column that provides the percentage of alerts by filings? In the attached example the new percentage column would ideally show me 0.9% (18/2043).
I couldn't for the life of me get anything to work, including using the pivot recipe which just blows my mind every time I try something with it.