Hi all,
I have a crosstab with two measures count and percent for each date in a week. and two summaries one total total(week) and one percent of that total.
Month(Jan to Dec) as data item
Week1 Week2 Total(Week) Summary
Date1 Date2 Date3
Count Percent Count Percent Count Percent
Status A 477 75% 176 26% 727 81% 1380 62%
Status B 152 24% 41 6% 160 18% 353 16%
Status C 10 2% 464 68% 9 1% 483 22%
Total Status 639 100% 681 100% 896 100% 2216 100%
I could able to get the percent at date level as ,
percentage([count] for [Date])
and summary percent as total([count] for [status])/total([count] for Month).
changed summary format to percent. and aggregation as calculated.
I am getting the summary level percent by status A,B,C WHICH ARE 62%,16%,22% but the grand percentage at the end i.e.100% i am getting like either 33% or 22%...etc.
Why is it? and how can i get the 100% like the other percatage totals.
Can anyone please reply. This is a very urgent request.
Thanks in advance.