Hi,
I have a crosstab woth 2 measures. i need total summary for one and a percent for another. i got the total but still need to get the percent of total. Please see the crosstab eg:
eg:
week1 | week2 total(week) percent(week)
|date1 | date2 | date3 | date4 | date5 (M1) (M2)
m1 m2 | m1 m2 | m1 m2 | m1 m2 | m1 m2
Row
total of row
Here m1 is the count and m2 is a percent.
total(week) is total of m1 for the crosstab. and percent of m2 should be percent of this grand total. Hope you get it what i am trying to say.
So, how do i get the percent of the summarized total. at a time it's allowing only summary for one measure.
Please help. thanks in advance.
I have a crosstab woth 2 measures. i need total summary for one and a percent for another. i got the total but still need to get the percent of total. Please see the crosstab eg:
eg:
week1 | week2 total(week) percent(week)
|date1 | date2 | date3 | date4 | date5 (M1) (M2)
m1 m2 | m1 m2 | m1 m2 | m1 m2 | m1 m2
Row
total of row
Here m1 is the count and m2 is a percent.
total(week) is total of m1 for the crosstab. and percent of m2 should be percent of this grand total. Hope you get it what i am trying to say.
So, how do i get the percent of the summarized total. at a time it's allowing only summary for one measure.
Please help. thanks in advance.