I am aware that lot of questions have been asked about % of total but I could not find the specific question I am looking for.
Sample data & explore
Total active email addresses: 50
I have four activities with 25 email addresses undertaking each activity with some email addresses undertaking multiple activities. A simple table calc of value/sum(value) gives me % of the table total whis is 50% each. I am looking for % of total against Total active email addresses.
Is there a way to achive this without making a database change or a derived table? A merged Look could work; I am trying to see if this can be achieved in a single Look.
Best answer by MaddieView original