I believe this is an age old question or perhaps I'm overly excited about the new summarizations in Monarch V10 but here goes. I want my measure to give me the percentage of the subtotal but since I have an across summary, it seems that the percentages are reflecting the subtotal of the data across and the TOTAL reflects the cumulative of the GRAND TOTAL. I want the TOTAL to reflect the cumulative of the subtotal.
Key = Site, Ins, Month(Across)
Measure = Count(), COUNTSUBPCT()
This is how it is......
[FONT=Times New Roman] HMO 10 5 5 20 50 25 25 24 /FONT[/SIZE]
Can I get what I want?:confused: