This content has been marked as final.
Show 3 replies
-
1. Re: Display most recent calculated z score measures in a crosstab
Deepak Rai Mar 29, 2018 10:55 AM (in response to John McGuirk)Hi John,
Here it is, You need to First Pivot your data and then have to use LODs for A, B, and C and then Filter across for Last Value to get this:
Thanks
Deepak
-
ZscoreExample_DR.twbx 76.6 KB
-
-
2. Re: Display most recent calculated z score measures in a crosstab
Deepak Rai Mar 29, 2018 11:01 AM (in response to John McGuirk)2 of 2 people found this helpfulHi John,
After posting above, I went back to your sheet and realized that it was just matter of filter for MAX Value. So you may pick up whatever you need. This is from your Sheet 1.
-
3. Re: Display most recent calculated z score measures in a crosstab
John McGuirk Mar 29, 2018 11:16 AM (in response to Deepak Rai)Hi Deepak, this is great. Thank you! Your second solution is obviously easier but I appreciate your LOD solution as well. I would never have been able to come up with pivoting the data in an LOD calculation on my own. I will be doing some research on pivoting the data so I can use it going forward. Thanks again.