Rick, We do have some reports with only aggregrated % measure columns. So, if you can get me that other approach you mentioned for totalling an aggregated %measure sub-column, it will save redesigning the layout on some reports. This is a great feature though, in what version was it first introduced? On second thought, I went back and added the second column with the aggregate and did away with all the % only elements. They are another managers reports, so I'll have to see how he likes them, otherwise I'll be looking for the aggregate column only solution. Great suggestion on the name change as it saves a lot of column space. Also, once I make the name change to the new aggregate in the left hand data set, I just pull it over if I have an empty column or substitute it, if I have to create the new aggregate (then delete that one from the data column). We're cooking with gas now. Thanks again, Howard PA Patient Safety Authority Message was edited by: Howard Newstadt ... View more

Rick, Thank you. that worked!!! I take back everything I said about the developers. Not I'll have to teach the engineer how to do it. ... View more

Skillman, thanks for your reply, but no it doesn't. In the first chart you are only reflecting 1 year's data in the same year column, so you obviously get 100%. In your drill down, the quarterly columns each should add to 100% to be able to compare quarterly rates, but they don't, instead they show the percent each quarter makes up of the total year. This is fine for the totals, but pretty useless for the rows. This gets even worse when you filter for several years.. ... View more

Michelle, thought you were from SAS. Appreciate your reply and the fact that you previous raised this feature request. I am just flabergasted that it has not been addressed by the development team. ... View more

Seriously. This is one of the most basic of measurements that is expected to be made in almost any business environment. For all the very good functionality in VA, the product FAILS on this feature is absent. SAS VA development needs to get it together in a big hurry. Which they apparently have. thanks. hn Message was edited by: Howard Newstadt ... View more

Michelle, This is not a problem, it is a product defect.(Apparently not, as there is an excellent solution - hn). Message was edited by: Howard Newstadt ... View more

How would you get Percent of Subtotals in a Cross Tab? ... View more

Here is an example of what I'm asking about. I want the quarterly Frequency Percent columns to total 100% and each cell within the quarter to be a percentage of that quarter's results and add up to 100%: ... View more