
1. Re: Creating a table of calculations with multiple discrete dimensions as rows
Shinichiro Murakami Oct 12, 2016 5:50 PM (in response to Victor Bartash)To be honest,
I'm afraid the ZIP CSV makes people to hesitate to download the attachment including me.
Most of the people prefer to have packaged workbook.(***.twbx)
If your file is bigger than 1MB, I recommend that you filter the datasrouce and reduce the file size.
If the size is small enough, please attach the packaged workbook itself without pressing.
Thanks,
Shin

2. Re: Creating a table of calculations with multiple discrete dimensions as rows
Victor Bartash Oct 13, 2016 1:18 AM (in response to Shinichiro Murakami)Shin,
Thanks so much for the tip! I apologize for having attached the file that way. I've now attached it as a ***.twbx.
Thanks again!
Victor

3. Re: Creating a table of calculations with multiple discrete dimensions as rows
Victor Bartash Oct 13, 2016 7:44 AM (in response to Victor Bartash)Bump. Can anybody help?

4. Re: Creating a table of calculations with multiple discrete dimensions as rows
Shinichiro Murakami Oct 13, 2016 8:12 AM (in response to Victor Bartash)Be patient, please.
Shin

5. Re: Creating a table of calculations with multiple discrete dimensions as rows
Shinichiro Murakami Oct 13, 2016 9:17 AM (in response to Victor Bartash)I don't know the logic of"Delta" make sense or not, anyways here is a table based on your descriptions.
Simple table can be created thru table calculation which is pretty similar as excel pivot.
Combined one requires individual calculated field.
[Rejection Rate]
sum(if [Stage]="Rejected" then [Number of Records] end)
/
sum([Number of Records])
[Application Rate]
sum([Number of Records])/attr({fixed:sum([Number of Records])})
FIXED Level of Detail Expressions
[Delta]
[Application Rate][Rejection Rate]
Then create three worksheet with different slice, then combine them on dashboard.
Thanks,
Shin