A macro to typeset a difficult table
Updated answer shows two versions, a simple one without calculation and checks and a second one which does the calculation.
\documentclass{article}
\usepackage{tabu}
\usepackage{multirow}
\begin{document}
\newtabulinestyle{stip=on 1.5pt off 2pt}
\begin{tabu} to \linewidth {X[0.8l]X[2.5l]X[c]X[c]X[c]X[c]X[c]} \hline
\rowfont{\bfseries} \multicolumn{2}{c}{\multirow{2}{*} {NUMBERS}} &
\multicolumn{2}{c}{Type} & \multicolumn{2}{c}{Size} &
\multirow{2}{*}{All} \\
& & A & B & Big & Small & \\ \hline
\multicolumn{2}{l}{Good} & 1 & 4 & 2 & 3 & 5\\ \tabucline[stip]{-}
\multirow{3}{*}{Ugly} & Cow & 7 & 1 & 4 & 4 & 8 \\ \tabucline[stip]{2-}
& Goat & 1 & 2 & 0 & 3 & 3 \\ \tabucline[stip]{2-}
& Horse & 2& 1 & 3 & 0 & 3 \\ \tabucline[stip]{-}
\multicolumn{2}{l}{Bad}& 12 & 1 & 6 & 7 & 13 \\ \hline
\rowfont{\bfseries} \multicolumn{2}{l}{TOTAL} & 23 & 9 & 15 & 17 & 32 \\ \hline
\end{tabu}
\def\mytable[#1]#2\\#3\\#4\\#5\\#6\\#7\end#8{%
\begin{tabu} to \linewidth {X[0.8l]X[2.5l]X[c]X[c]X[c]X[c]X[c]} \hline
\rowfont{\bfseries} \multicolumn{2}{c}{\multirow{2}{*} {#1}} &
\multicolumn{2}{c}{Type} & \multicolumn{2}{c}{Size} &
\multirow{2}{*}{All} \\
& & A & B & Big & Small & \\ \hline
\multicolumn{2}{l}{Good} \\\tabucline[stip]{-}
\multirow{3}{*}{Ugly} & Cow & #3 \\ \tabucline[stip]{2-}
& Goat & #4\\ \tabucline[stip]{2-}
& Horse & #5 \\ \tabucline[stip]{-}
\multicolumn{2}{l}{Bad}& #6 \\ \hline
\rowfont{\bfseries} \multicolumn{2}{l}{TOTAL} & #7 \\ \hline
\end{tabu}%
\end{mytable}}
\begin{mytable}[NUMBERS]
1 & 4 & 2 & 3 & 5 \\
7 & 1 & 4 & 4 & 8 \\
1 & 2 & 0 & 3 & 3 \\
2 & 1 & 3 & 0 & 3 \\
12 & 1 & 6 & 7 & 13 \\
23 & 9 & 15 & 17 & 32
\end{mytable}
\def\testrowone#1\\{%
\ifnum\numexpr#1+#2\relax=#5\else \typeout{A+B != All}\fi
\ifnum\numexpr#3+#4\relax=#5\else \typeout{big+small != All}\fi
}
\def\cella#1\\{#1}
\def\cellb#1\\{#2}
\def\cellc#1\\{#3}
\def\celld#1\\{#4}
\def\celle#1\\{#5}
\def\mytableb[#1]#2\\#3\\#4\\#5\\#6\\#7\end#8{%
\testrowone#2\\
\begin{tabu} to \linewidth {X[0.8l]X[2.5l]X[c]X[c]X[c]X[c]X[c]} \hline
\rowfont{\bfseries} \multicolumn{2}{c}{\multirow{2}{*} {#1}} &
\multicolumn{2}{c}{Type} & \multicolumn{2}{c}{Size} &
\multirow{2}{*}{All} \\
& & A & B & Big & Small & \\ \hline
\multicolumn{2}{l}{Good} \\\tabucline[stip]{-}
\multirow{3}{*}{Ugly} & Cow & #3 \\ \tabucline[stip]{2-}
& Goat & #4\\ \tabucline[stip]{2-}
& Horse & #5 \\ \tabucline[stip]{-}
\multicolumn{2}{l}{Bad}& #6 \\ \hline
\rowfont{\bfseries} \multicolumn{2}{l}{TOTAL} &
\the\numexpr \cella#2\\+\cella#3\\+\cella#4\\+\cella#5\\+\cella#6\\ \relax &
\the\numexpr \cellb#2\\+\cellb#3\\+\cellb#4\\+\cellb#5\\+\cellb#6\\ \relax &
\the\numexpr \cellc#2\\+\cellc#3\\+\cellc#4\\+\cellc#5\\+\cellc#6\\ \relax &
\the\numexpr \celld#2\\+\celld#3\\+\celld#4\\+\celld#5\\+\celld#6\\ \relax &
\the\numexpr \celle#2\\+\celle#3\\+\celle#4\\+\celle#5\\+\celle#6\\ \relax
\end{tabu}%
\end{mytableb}}
\begin{mytableb}[NUMBERS]
1 & 4 & 2 & 3 & 5 \\
7 & 1 & 4 & 4 & 8 \\
1 & 2 & 0 & 3 & 3 \\
2 & 1 & 3 & 0 & 3 \\
12 & 1 & 6 & 7 & 13 \\
\end{mytableb}
\end{document}
A half-baked pgfplotstable
solution. The column sums are missing but sanity check on the sums of rows are implemented (gives the stupid error in the screenshot if there is a discrepancy). Also the upper left corner text is optional you can change it when entering the table. With this you don't need to enter your data in a tabular format.
\documentclass{article}
\usepackage{pgfplotstable,multirow,booktabs}
\pgfplotstableset{toughtable/.style={
every head row/.style={before row={\toprule
\multicolumn{2}{c}{\multirow{2}{*}{\textbf{#1}}} &\multicolumn{2}{c}{Type} &\multicolumn{2}{c}{Size} &\multirow{2}{*}{All}\\
},
after row=\midrule
},
every last row/.style={after row=\bottomrule},
create on use/myfirstcol/.style ={create col/set list={Good,Ugly,,,Bad,\textbf{TOTAL}}},%A dummy column
create on use/mysecondcol/.style={create col/set list={,Cow,Goat,Horse,}},%A dummy column
create on use/summationcol/.style={
create col/expr={\thisrowno{0}+\thisrowno{1}-\thisrowno{2}-\thisrowno{3}==0?\thisrowno{0}+\thisrowno{1}:0}
},
columns={myfirstcol,mysecondcol,[index]0,[index]1,[index]2,[index]3,summationcol},
columns/myfirstcol/.style={string type,column name=,
assign cell content/.code={%
\ifnum\pgfplotstablerow=1\pgfkeyssetvalue{/pgfplots/table/@cell content}{\multirow{3}{*}{Ugly}}\fi
}
},
columns/mysecondcol/.style={string type,column name=},
columns/summationcol/.style={string type,column name=,
assign cell content/.code={
\pgfmathparse{\pgfkeysvalueof{/pgfplots/table/@preprocessed cell content}==0?int(1):int(0)}
\ifnum\pgfmathresult=1\relax
\pgfkeyssetvalue{/pgfplots/table/@cell content}{Chicken Run!!}%
\else
\pgfmathparse{int(\pgfkeysvalueof{/pgfplots/table/@unprocessed cell content})}
\edef\temp{\noexpand\pgfkeyssetvalue{/pgfplots/table/@cell content}{\pgfmathresult}}\temp
\fi
}
},
display columns/2/.style={column name=A},
display columns/3/.style={column name=B},
display columns/4/.style={column name=Big},
display columns/5/.style={column name=Small},
every row no 1/.style={before row=\hline,after row=\cmidrule{2-7}},
every row no 2/.style={after row=\cmidrule{2-7}},
every row no 3/.style={after row=\hline},
every row no 4/.style={after row=\hline},
}
}
\begin{document}
\pgfplotstabletypeset[toughtable=NUMBERS]{
1 4 2 3
7 1 3 4
1 2 0 3
2 1 3 0
12 1 6 7
}
\end{document}
I'll try to get the columns sum hopefully soon.