This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I created some pivot tables that show me the number of occurences grouped by some parameters in absolute terms. However, I'd like to get the result as a percentage not of row or column total, but of grand total (so both). Example from Excel Pivot table, where this is possible:
The percentages over both the columns and rows sum up to 100 %.
I'm not sure what your source data looks like, but it sounds like you will need to create the % of total calculation (in this example, I used the Summarize, Append and Formula tools) and then Cross Tab the data to put the rows and columns into the right place.