
1. Re: How do I create a 2D frequency table with more than one column, to store a number of calculated statistics?
Jonathan Drummey Dec 13, 2012 1:00 PM (in response to Daniel Ruszaj)1 of 1 people found this helpfulI'm not sure what you mean by percentage of row or column and how they are different from the total. In any case, you can set up table calculations that perform computations across the rows of your data in almost any way imaginable.
I've attached a simple worksheet with some examples, I suggest you check out the links at:
http://drawingwithnumbers.artisart.org/wanttolearntablecalculations/
for more info on table calculations.

2. Re: How do I create a 2D frequency table with more than one column, to store a number of calculated statistics?
Joe Mako Dec 15, 2012 1:22 PM (in response to Daniel Ruszaj)Jonathan has complied some great resources. If you want to see them applied to your data, see the attached.
It seems like your above sample calcs are not correct for the "pct" column, there is a total count of 900, not 1000, or I do not understand what the calc for that column should be.

pct example.twbx.zip 23.0 KB


3. Re: How do I create a 2D frequency table with more than one column, to store a number of calculated statistics?
Daniel Ruszaj Dec 17, 2012 10:16 AM (in response to Joe Mako)Thank you both very much for your help. Part of what was tripping me up (besides the table calculations) is that you can only put one field onto the text box of the Marks shelf. But I see now that you can get around that by putting Measure Values there and placing multiple fields into that, and in so doing create multiple columns. Appreciate it.