Hi,
On my row shelf I have 2 dimensions. In the mark shelf I have CNT() of the measure equivalent (unbinned version) of one of those dimensions. This gives me a basic frequency report with a single column which shows me the count.
My issue is I would like to show more than just the count. I'd like to show count, percentage of total, percentage of row, and percentage of column, in four columns side-by-side. Is this possible in Tableau? Here is an example of what I'm going for. The first two columns in the below table are dimensions, the rest are computed.
Thanks for your help.
acctBal_binlimit_bincountpctpctColpctRow
0000.0000.0000.000
0(0,500)00.0000.0000.000
0[500,1000)00.0000.0000.000
0[1000,2000)00.0000.0000.000
0[2000,+)00.0000.0000.000
0*m00.0000.0000.000
0*e00.0000.0000.000
(0,500)000.0000.0000.000
(0,500)(0,500)393.900100.00095.122
(0,500)[500,1000)20.2006.8974.878
(0,500)[1000,2000)00.0000.0000.000
(0,500)[2000,+)00.0000.0000.000
(0,500)*m00.0000.0000.000
(0,500)*e00.0000.0000.000
[500,1000)000.0000.0000.000
[500,1000)(0,500)00.0000.0000.000
[500,1000)[500,1000)272.70093.10379.412
[500,1000)[1000,2000)70.7008.75020.588
[500,1000)[2000,+)00.0000.0000.000
[500,1000)*m00.0000.0000.000
[500,1000)*e00.0000.0000.000
[1000,2000)000.0000.0000.000
[1000,2000)(0,500)00.0000.0000.000
[1000,2000)[500,1000)00.0000.0000.000
[1000,2000)[1000,2000)737.30091.25083.908
[1000,2000)[2000,+)141.4001.86216.092
[1000,2000)*m00.0000.0000.000
[1000,2000)*e00.0000.0000.000
[2000,+)000.0000.0000.000
[2000,+)(0,500)00.0000.0000.000
[2000,+)[500,1000)00.0000.0000.000
[2000,+)[1000,2000)00.0000.0000.000
[2000,+)[2000,+)73873.80098.138100.000
[2000,+)*m00.0000.0000.000
[2000,+)*e00.0000.0000.000
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.
